I believe the reason people worry less about hydroelectric dam failures is because, if they fail, they do not leave behind a contaminated area. Besides, it's just water; many people are used to floods caused by heavy rain, and the danger feels similar. In fact, hydroelectric dams can even help prevent (or contain) flooding, so it's the opposite of causing damage in that case. Of course, we're not talking about tailings dams, which do leave behind a trail of contamination when they fail.
(An interesting case is the failure of a tailings dam many years ago which flooded the Rio Doce with pollution, with that flood being mostly stopped by a hydroelectric dam downriver. The hydroelectric dam contained the damage instead of causing it.)