IMO they look pretty ugly and visually mar the landscape. They do so less than power plants and pollution and are a necessary evil for modern society to function. They look cool because of what they stand for and because they are novel (and because they’re new and clean, generally).
I do worry about what will happen when they are decommissioned, as there are currently no ways to recycle the blades due to the way they are manufactured.