For example, a recent poll on "spoiled landscape":

Holiday plans affected by windfarms - Environment - Scotsman.com

A total of 80 per cent of people in the UK - and 83 per cent of Scots surveyed - said the presence of a wind farm would not affect their decision about where to stay when on a holiday or short break in Britain.

When asked if wind farms spoiled the look of the countryside, 52.1 per cent of people in both Scotland and across the UK disagreed, with a further 29.3 per cent in the UK and 28.3 per cent of Scots saying they neither agreed nor disagreed.

Only 18.7 per cent in the UK and 19.6 per cent of Scots said wind farms did spoil the look of the countryside.

The most in-depth poll I saw which focused specifically on local opinion, was also from Scotland nine years ago, and found that people closest to the wind farms are the most supportive:

Public Attitudes to Windfarms: A Survey of Local Residents in Scotland

• People living close to windfarms (within 20 km) like the areas they live in, mentioning the peacefulness (28%), scenery (26%), rural isolation (23%) and friendly people (20%) as particular strengths. When asked to say what the shortcomings are, most commonly mentioned are a lack of amenities (20%), poor public transport (18%), and lack of jobs (8%). Just five people (0.3%) spontaneously mention windfarms as a negative aspect of their area.

• Three times the number of residents say that their local windfarm has had a broadly positive impact on the area (20%) than say that it has had a negative impact (7%). Most (73%) feel that it has had neither a positive nor negative impact, or expressed no opinion.

• People who lived in their homes before the site was developed say that, in advance of the windfarm development, they thought that problems might be caused by its impact on the landscape (27%), traffic during construction (19%) and noise during construction (15%). However, only 12% say the landscape has been spoiled, 6% say there were problems with additional traffic, and 4% say there was noise or disturbance from traffic during construction.

• ...People living closest to the windfarms tend to be most positive about them (44% of those living within 5km say the windfarm has had a positive impact, compared with 16% of those living 10-20km away). They are also most supportive of expansion of the sites (65% of those in the 5km zone support 50% expansion, compared with 53% of those in the 10-20km zone).

• Similarly, those who most frequently see the windfarms in their day-to-day lives tend to be most favourable towards them (33% of those who see the turbines all the time or frequently say the windfarms have had a positive impact on the area, while 18% of those who only see them occasionally say the same).

_{*Lunatic*, n.
One whose delusions are out of fashion.}

I can't cite a poll offhand, but I have personal knowledge of a groundswell of opposition to windmills in rural areas of SW France and in the Mediterranean coastal strip of Languedoc (flat, uninspiring landscape for the most part). I know people in hilly country who are undoubtedly "green-minded" who are passionately determined to prevent skyline wind projects (and they are succeeding). And the coastal opposition seems to veer towards threats of violence and sabotage (I have seen roadside graffiti threatening the "wind lobbyists" with the "rising anger" of the people).