How about any of the reservoirs in drought-stricken North America? Water could be pumped to Lake Mead, power generated at Hoover Dam, and then enter irrigation for farmland. Same for almost the entirety of the Snake River and tributaries.
Maybe you weren't aware, but those sites are drying out thanks to climate change, and have some other important responsibilities like drinking water
Hydro is failing worldwide. Look it up before responding please, thanks.
Cant find it now but there was a study i remember seeing that suggested that there were 100x as many as needed.