> A gas-based design seems like it would be better at a small scale

The major advantage over pumped hydro would be you do not need very specific geography to make it happen (90 - 300+m change in elevation)