I live a couple of miles away from a windfarm. It's not directly visible, because my home is down in a valley, but it's by the main road into the town so you couldn't miss it. Now that I've set the scene, I can make my declaration: yes, they are awesome, quietly spinning giants, and no, the feeling doesn't wear off :)

Nonetheless, I'll have to admit they are a bit noisy. If you're right underneath them, it's not so pleasant - but it's better than living by a main road, and especially so when there are internal combustion engine vehicles about. Thus, it's a tradeoff I'd personally be willing to take if it meant more sustainably-powered electric vehicles.