Ah, sometimes it can look quite nice, or at least striking. Though usually after end of life. The Tate Modern in London is an old power station, and a disused oil power plant in Dublin (https://en.wikipedia.org/wiki/Poolbeg_Generating_Station#Poo...) has become sufficiently iconic that its operator was refused permission to demolish its chimneys; they're now protected structures.

A huge coal power plant belching smoke probably looked pretty cool, maybe even majestic, the first time you saw London back in the Victorian Era. That's before the entire city became saturated in soot, you developed respiratory problems, and you'd seen the same stinky monstrosity every day for most of your short difficult life.

I like wind farms, but I think it's fair to observe that they're often built in nice places, whereas fossil fuel infrastructure is built in places you'd never go to voluntarily.