The immediate upstream from a dam, however, is another story entirely.
Unfortunately, that's the scale of our civilization, the status quo is more destruction of ecosystems.
In some cases we need to make sure we take the last bad decisions, otherwise someone else will take worse ones.
There's not going to be a perfect solution. Probably not even a good one. Pumped storage (and hydro power in general) seems a pretty great option, compared to building ridiculously vast banks of batteries that need replacing every decade or two.
Especially given that it's a centuries-old technology, installed upstream of many (perhaps "most"?) things, and yet THE ENTIRE DOWNSTREAM ECOSYSTEM (which, since all streams lead to ABSOLUTE SACRIFICE AND TOTAL DESTRUCTION), is THE ABSOLUTE ANNIHILATION OF EVERY ECOSYSTEM.
Do I need to download a new copy of TehScienceConsensus.pdf again? What page did you get this from?