I'm all for wind in its correct application--as an extra power supply.
They put in a pretty big wind farm near where I went to college...it apparently alleviated a large portion of energy costs from NYSEG (NY power, more or less) in the most impoverished counties in the state. Not sure how it affected their little economic sliver...
The wind farm was actually an attraction--people from nearby visited the dying town of Chateaugay. Again, don't know how it affected the local economy.
Is wind the end all of power issues? No, but it's better than a fair amount of alternatives. Every kind of power plant is going to affect the local ecosystem--there's no getting around that. Wind is a good way to use renewable energy in order to support established power plants already producing.
Back to my personal experience with the Chateaugay, NY wind farm: The land was purchased and I believe that nearby farmers were paid and will continue to be paid for the land that they owned. The land lease was said to be profitable beyond what that section of their land could have produced, and the farmers all seemed happy to lease/sell their land to the wind farm.
I guess it's all about political conviction for a lot of people. They would rather see the traditional power plants stick around than look for new alternatives simply because the "opposition" (ridiculous) supports it.
on a side note, Al Gore has been the worst thing that has ever happened to "environmental awareness." He has caused a lot of people to stop considering any sort of study on planetary health simply because he won't shut the hell up.
*edit* here's a link to the article about Noble Power from a couple years back when they first started the project:
Chateaugay wind farm