I also actually really like the look of wind turbines. They seems to be just the right blend of graceful, majestic and futuristic.
The old 2-blade ones are a bit visually noisy as they look like they oscillate, but they're basically extinct now.
I am somewhat sympathetic to, in the case of wind, low-frequency noise complaints, but I strongly suspect most of them are just tacked on for good measure.