I've only read a little about this, but from what I understand, it's hard to find places that are actually good for this - and the volume of water you need to produce a significant amount of energy is quite large for given place where you can get enough height.
My intuition is it's probably better to just over-deploy wind and other renewables - pumps and turbines are not exactly free or easy to maintain either.