Exactly. I'm not "scared" of nuclear power, I'm an engineer and I understand the concepts of risk and failure mode effects analysis. The problem is primarily management failures in most of these high-profile accidents, as summarized by the poster above. There is no way to eliminate those on long enough time scales because human beings make mistakes. The problem with nuclear power is that the catastrophe scenario is very, very bad, and the timescale to react is very short. The latest update from Fukushima is that according to simulations based on the data they have, the Unit 1 reactor began melting down within 16 hours after loss of core cooling.
My feeling from reading some of the responses from people who are in favor of nuclear power is that for some people it reduces to an attachment to the technology. It's pretty cool to have the ability to split the atom to generate power (even though it's ultimately just boiling water). There's a visceral pride we feel in being able to harness something inherently very dangerous. Until it gets away from us.