What about the new lakes generated by the dams? What about using these lakes as water reservoir needed for agriculture?

There are certainly different kinds of hydropower. Some generating a large lake for a little power output while others in the mountains of an area with heavy rainfall generate a lot of power without flooding a large area. Yet, it seems that all hydropower projects are either labelled "good" or "bad".