No. First off, most dams silt up, not only not of being use in storing water but also not in creating power. Second, once they silt up, whatever ecosystem there is also destroyed and artificially created ecosystems are never natural and usually are bad for local fish populations. Artificial lakes can also host a number of non-native fish and are not any benefit to the native species that should be living there. Also, dams also block the migration paths of native fish.

Just think of this way, dams have a life span and for the most part, most of them in US have hit the end of their life spans and should be removed. They serve no purpose to anyone.