This guy (https://www.youtube.com/watch?v=tMLu9Dtw9yI) makes some good points about how cheap and scalable the technology is for medium-scale energy storage. It uses tried and tested, reliable and simple components for example
My brother has a steep hill on his property and Ive been wondering about the feasibility of PSH. How high the tank should be, the equipment, the power output.
I suspect the amount of energy is far less than you are imagining... It takes a lot of water to generate a useful amount of energy. This video (https://www.youtube.com/watch?v=66YRCjkxIcg) does an interesting demo and points out that a 5 gallon bucket on a ladder has the same potential energy as a watch battery.
It at least gets you all the right words to start googling for turbine options which helped me to do some back of the envelope math. It's a steeper hill than seemed feasible to me.
He doesn't need the pumped storage part of the equation due to a natural water flow, but it is part of the solution at least.