But as far as the new ones: I recently moved offices in Copenhagen, to a 5th-story office looking east towards the Øresund. I think the offshore wind farm there adds substantially to the view (http://en.wikipedia.org/wiki/Middelgrunden). It's especially nice on overcast, windy, gray days, when you can see the white turbines rotating in the fog. But it's nice on sunny days too, at least in my opinion. Here's a snapshot from my window: http://sphotos-b.xx.fbcdn.net/hphotos-snc7/598966_1010047304...
And if you get closer, e.g. at Amager Beach, it's even nicer (again imo). It's like a modernist kinetic sculpture or something, an aesthetically pleasing series of 20 massive but sleekly styled turbines in a row.
However, in Denmark you can make an interesting experiment in several places. You can place yourself so that you are in 100-500m from a windmill AND have a road with traffic between you and the windmill.
What kind of noise, vibrations and view do you think are significant in that situation?