I feel like the crux of the problem, as usual, is education (and likely trust). If you're not aware of modern reactor tech, or you don't believe those telling you, then you're probably just expecting an inevitable Chernobyl.
For how long did TEPCO fake their safety records? Private capital is far too single minded and powerful to be responsible for nuclear power plant safety.
About the only sources of power that people don't object to are photovoltaic solar and tidal, which produce only piddling amounts of energy (and probably most people don't know enough about tidal to find some reason to object to it).
In truth, no one wants to live near anything that smacks of industry. Even trying to find places to put the trunk power lines or substations can find a lot of resistance, so sticking power plants in the middle of nowhere doesn't really solve the NIMBY problem.
Germany found a solution for that: Underground.
The power plants generally are pretty dull industrial sites. I don't blame for people not wanting them in their back yard. Luckily, one does not need to build them near habitation. There's plenty of space.
Most people don't know or care except if it's super obvious (generating tons of obvious smoke/steam). However, they will raise all sorts of fuss while it's being proposed.
At night, you can look out across the flat terrain and see dozens of red lights, blinking in unison. Every time, I think to myself, "This place wouldn't be half bad for riding out the zombie apocalypse."
Though now that you mention aliens, the first strikes of an alien invasion are far more likely to hit the more centralized generator plants, so areas served by wind farms might just retain grid power long enough to organize some form of resistance. Or at least until the second-wave bombers arrive.
When I stand next to one, I just think "free electricity" and sometimes also "free bird stew", but usually "Why don't these things get covered in graffiti?"
Genuinely curious. I've never heard of a phobia like yours before, is it just because of the motion, or is there something different about steel towers than stone ones?
Source? Can I buy a house near a nuclear plant for 50% off? If so I'm down. I'll even increase my "risks" by buying a Ferrari with the savings I made off the irrational fools :)
Frankly any energy production other than solar is rather undesirable to live near.