If you really want to pay extra for having nuclear waste in your garden, you can do so as long as it is at least 1000 km from my garden. The only use left for Uranium is military. Modern nuclear power is one of the most expensive energy options. From Texas:
It is probably more instructive to consider these accidents in terms of how bad they could be, because eventually, there will be an accident that will be as bad as could be. So, for examples from the wiki you linked to:
Hydro: “August 1975: The Banqiao Dam flooded in the Henan Province of China due to heavy rains and poor construction quality of the dam, which was built during Great Leap Forward. The flood immediately killed over 100,000 people, and another 150,000 died of subsequent epidemic diseases and famine, bringing the total death toll to around 250,000—making it the worst technical disaster ever. In addition, about 5,960,000 buildings collapsed, and 11 million residents were made homeless.”
Coal: “April 26, 1942: A coal-dust explosion at Benxihu Colliery in Japanese occupied China killed 1,549”. Moreover, “In the US alone, more than 100,000 coal miners were killed in accidents over the past century,” and “600,000 Chinese coal miners, as of 2004, were suffering from Coalworker's pneumoconiosis (known as "black lung") a disease of the lungs caused by long-continued inhalation of coal dust. And the figure increases by 70,000 miners every year in China.”. Also.: Coal Mining Disasters
Gas: “November 19, 1984: San Juanico Disaster, an explosion at a liquid petroleum gas tank farm killed hundreds and injured thousands in San Juanico, Mexico.”
So, from the above it becomes clear that it is probably only a matter of time before there will be an accident in a nuclear power plant that will be as bad as such an accident could be. Chernobyl afforded us a glimpse of the sort of horror that such an accident might unleash. It was a catastrophe that released approximately four hundred times more radioactive material than that which was released by the atomic bombing of Hiroshima and Nagasaki and that has left large areas of land in Russia, Ukraine and elsewhere contaminated, but yet it could have been so very much worse, and indeed would have been, but for some extraordinary heroic and self-sacrifice efforts. So in some respects, as a global population, we were very lucky. Eventually though, our luck is certain to run out, and it is then that an “as bad as it could be” nuclear accident will happen.
Actually, the city of Fukushima is quite nice--I wouldn't mind living there one bit.
The exclusion zone is another matter, but even that's gradually coming back. Contrast with some of the US Superfund sites, which may never be cleaned up.