Many dams are going to exist due to flooding, irrigation, etc. Extracting hydropower once you have already decided to build a dam is as close to fully green as it gets.
That said, there are many low head dams built exclusively to extract power, and many of those are no longer serving a useful purpose.
That said, there are many low head dams built exclusively to extract power, and many of those are no longer serving a useful purpose.