Hydro is the best, so good in fact that most of the good spots are already taken, because as you said, it requires a very specific geography.
The business model for pumped hydro requires relatively low cost to be economic and if it requires building a giant concrete water retention systems on top of large flat topped hills/mesas, near large drops in elevation, with water retention at the bottom of the large drop that is also really really expensive to build and requires specific geology to be economic.
And if something gets messed up, it’s a huge liability [https://en.m.wikipedia.org/wiki/Taum_Sauk_Hydroelectric_Powe...], as it can cause very damaging flooding and be expensive to repair/replace.
Worth doing when there is cheap power that can be stored and sold at higher rates later, but construction costs are really a huge part of it.
I'm fairly certain we have these multi level semi natural systems here in Norway, but I am not sure if we use them for pumped hydro.
(Og course, if one doesn't care about ecology, one of those levels can be the sea.)
My crazy idea would be to use the heat and the pressure of these to pump water uphill. It is of course a crazy idea and you'd have to figure out a way to manage the pressure peak
But it would be very interesting