The world needs a new source of energy, an unspillable source.

why are small-scale hydroelectric plants more sustainable than large scale?

I get the whole concept of sustainability but apart from that I don’t see why smaller scale stations are more sustainable than large-scale stations.
And does it also depend on the location? Are some small scale projects more sustainable in certain areas?