I'm really unclear how nuclear plants are better than, say, a similar investment in solar panels and battery backups. The elimination of waste disposal alone is a huge improvement, and while it's true that nuclear is generally safe, it still seems that we get a new massive cleanup project every few decades.
It's a reliable, stable, high-yield power supply that is quite straightforward in many ways. It's just another thermal power plant after all.
There are nuclear reactor concepts that would largely eliminate most of the waste and safety issues of current fission reactors. Perhaps the events in Japan will lead to a funding blitz. One can hope.
I understand that nuclear reactors rarely fail, and will never fail like Chernobyl again, but if the Fukishima plant had been, for instance, a natural gas plant or windfarm, it would merely have been destroyed. As it is, it will at very least cost an extraordinary amount of money to clean up.
All I'm saying is that even if nuke plants fail less often than other plants do, and assuming that moving waste and fuel to and from all the other facilities (storage ponds, refineries, fuel storage, reclamation plants...) never fails, then we still see at least some kind of minor nuclear accident every few decades. I wouldn't care particularly about living near a plant, but when there are many nukes around the world, we see that one of them is going to go wrong eventually.
There are places where nuclear is suitable; nuclear subs have a clear advantage over conventional, and spacecraft could certainly use it, as well as anything in a place where getting new fuel to it is a problem and renewable energy is out of the question (mountaintops, deep sea, ect).
It's a moot point either way, of course. We will not see another nuclear plant built in our lifetimes outside of Iran, or other places where it's seen as a technical achievement rather than a hazard. This has nothing to do with how safe it actually is, but rather how safe it appears.
It's plausible (though I don't know how likely) that fusion will be made practical before fission is politically acceptable.
I prefer geothermal plants. They cost less to operate than coal, even the "deep" ones that can be built anywhere. There have been mumbo-jumbo myths that they cause earthquakes, but I would like to see that happen in, for instance, Ohio.