Unlike coal or nuclear, renewables are easily scaled down without creating a huge risk: for coal, you want to go large for efficiency reasons and to ensure that the right set of filters are installed and maintained. For nuclear, there were ideas of building a nuclear power plant in every basement, but given how the power plants we have look like military bases, that seems rather unfeasible.
Once you go big, you have the issues mentioned elsewhere in the thread (sunk cost fallacy, NIMBY, ...) but also corruption and that these big sites become single points of failure.
Dams are in the same space: NIMBY, once started you can't stop, large scale construction (which is rife with corruption).
Create financially reasonable basement/rooftop level nuclear or coal systems that can be safely installed by any random electrician and operated by the home owner and the entire discussion may shift.
beacuse they stop working
They interfere with fish migration. For some species, this means disrupting their reproductive cycle.
They gradually accumulate sediment, so their reservoir slowly fills up and turns into land. This is one of the issues with the Aswan Dam, which is projected to have a much shorter lifespan than was initially projected due to high sediment accumulation.
The Aswan met all of its goals, but it's a disaster. The sediment rapidly accumulating behind the dam used to provide free fertilizer for farmers. Use of commercial fertilizer skyrocketed.
It's also the cause of a serious health crisis. Schistosomiasis cases have also skyrocketed.
The annual floods used to keep snail populations in check. The snails are the vector for this gruesome parasitic infection.