If you use a valve that requires power to keep it closed to prevent a leak - and you have leak - and your power goes out. What is going to happen then?
NOT a good idea.
Use a system designed for this - such as WaterCop.
You will still want a battery backup for such a valve so you can shut the valve (if desired) in event of a extended power outage but the valve will stay shut (or open) without power.
<I will say that I have this installed on the main line coming in rather than at the point of use.>
It's all probabilities.
With a NC valve there is 100% probability that you will need to burn power every day to have water.
If you look at the draw of those valves it is around 44 watts. 24 hours is 1kWh, or 31.7kWh per month.
Quite a bit! That's ~8% of my monthly bill.
Even with the 12V valve at 25 watts it is substantial. 18kWh/month.
And that doesn't inclue the power consumed converting 120V to 12V.
On the other hand there is a very low probability that you will have a simultaneous water leak and power outage.
Plus if there IS a power outage you will lose all water to the house with a NC valve. Even if there isn't a leak.
A NO valve mirrors the behavior on the water line if there wasn't a valve there at all.
So you always have service, even in a power outage.
But you have the extra capability of being able to automatically secure it if there is a leak detected.
In the off chance you have a leak, THEN you start drawing power to close the valve.
You simulatneously have your system notify you so you can restore service.
A NC valve might be a good idea on a vacation home that only sees occasional use. So the water is secured when you are gone, and no power is drawn.
If you want to hedge against a simultaneous leak and power outage, you can use a 12VDC NO valve with battery backup.
Or use a shuttle valve that requires transient power to move it on or off, but doesn't require it to maintain one state.
But those valves are more expensive. Since the OP asked for a less expensive alternative, these provide that.