Cheap DIY water shut off valve

You are absolutely right that it shouldn’t be automated.

I meant manually literally, using hands operated mechanisms. Some of those valves have levers, cranks or wheels so they can be closed/opened even without power.