This from world economic forum in 2019 - Here’s how we can use agriculture to fight climate change suggests a starting place for reading.

Another large scale kind of project we have data for is when we have made things like dams for power or flood control. The lakes created have big effects on climate.

This resource - takes the position that hydro dams are to be avoided (which I disagree with) but also raises questions that every project should consider. Someone at National Geographic also has the opinion that dams are bad but again it seems to me that dams give us another lever to adjust to reduce problems like flooding / agricultural water use / drought.