All the best sites were built on long ago. Dams require favorable geography. More can be built to squeeze out a bit more storage, but there are diminishing returns.

https://www.ppic.org/publication/dams-in-california/