The problem is really down to finding places where you can actually build something like a hydroelectric power plant.

You need a large area you can safely flood. (No villages in the area or only villages you can buy out the owners of) or a high up lake.

The area to flood needs to have the geology required to construct a dam safely.

And finally, the area needs to be pretty high up and have an area below you can direct the outgoing water to.

so-called “gravity batteries” is pretty much exactly a dam with a mini-dam/reservoir at the bottom. When there is an excess, you run the motor to reverse the waterflow to pump uphill into a highe-elevation water retention pond/mini-dam.

This also helps reduce the amount of outflow water “lost” due to high-demand. Since you could take almost a day to fill the bottom reservoir and spend “wind”/solar to pump back the “lost” water downstream back into the higher-level reservoir.

Even if things are inefficient wind/solar are “renewable”, so you can keep “wasting” excess to replenish the dam and still make enough money back ( think in-terms of drought, flooding, windy, sunny, cloudy, etc ) you can basically keep the high-output “system” always topped-up with water. And still supply water + electricity as it is needed. There is no “downside”.

Not everyone agrees. So opinions can differ.