With water being charged at a rate of over 1 per m3 in the UK, a 80pis head of water and turbine efficiency of say 70% you would run at a loss of over 100 per kWh.
This assumes 15p/kWh, 11.3kW at head height of 55m (78psi), 70% efficiency and flow rate of 30 litres per second using 108m3 of water per hour.
If your not metered then your generated power is costing everyone else on the network more than the value you are getting so depends on if you view that as fair. That is in the case the water is just flowing to get the power and put directly into the drain.
The alternative view is to fill up a bath (say 100 litres) with water you could get around 11Wh out, so just enough to charge a single cell.
Hydro is great but the physical scale of water and heights involved is sometimes a magnitude or more larger than we think..
Appologies if my calcs are out slightly..
Another point is the pressure is needed in some instances to push the water into and through the pipework at a rate that allows a shower and boiler to work at a flow rate the typical non energy sensitive consumer wants.... drop the pressure the flow drops... just like volts in a battery.
Some hydro in Norway is over 1000m head height and over 1400pis, minly rock tunnels with steel piping at the turbines and lead-in / out. The main issue with hydro is avoiding water hammer whn you try to stop many tonnes of water from moving in a pipe with a valve, imagine trying to stop a train 3000m long in the space of 5 seconds. Water can create massive energy surges that even the pipes will not hold and hydro schemes can have surge pipes to allow the high pressures to flow out or bypass.
Supercaps can store energy very quickly but you then still need a generator to create the power and this is the issue of having a generator designed for short multi second pulses running 24x7 at a fraction of its capacity.