In Germany we always had very strict laws that regulate how long a house can be shaded by a wind turbine per year (8h/year, 30min/day iirc), only recently politicians started imposing arbitrary distance rules based on wrong information about noise immissions. I'd rather have a wind turbine close to my house than a road, provided I'm not in the flicker-shadow region of the blades.
That sounds far from optimal to me. If sea turbines are, say, five times more efficient and legally/socially non-problematic, why not just cover the sea with them as far as possible?
They're more expensive, require more infrastructure (pylons and electricity lines aren't conflict free either) and there are a lot of conflicts around use of seawaters. And for a country like Germany there simply isn't enough space within the north sea and baltic sea for all the wind power we'll need.
(And to be clear: I'm 100% supportive of offshore wind energy, I just think it's entirely unrealistic to assume that could be a replacement for onshore wind. We need both.)
I'm sympathetic, I really am, but these small harms need to be weighed against the effects of unchecked climate change!
What exactly is it about a wind turbine within 1000m of your home that bothers you?
As to your question: sound and sight. I definitely believe in smarter urban planning that just does not mash power plants and residential building together.
There are 'activists' everywhere, there are even 'activists' who campaign for the age of consent to be lowered because they want to have sex with 12 year olds. Being an activist is only as positive as the cause and the motives.
No, I want them in reasonable distance from villages and cities. Say, 1 and more km. I do not want to push them into anyone's backyard.
And that is actually entirely possible, unlike with, say, highways or railways that fundamentally connect human habitation with another human habitation. Even Europe has a lot of empty corners.
People don't like their view to change and equate that emotional impact with more substantive impact to nature. Landscape does matter, but not very much in comparison to more pressing matters. I think future generations will shake their heads at our willingness to pander to emotion.
Visit a place than mixes industry and residential sensibly, like Japan before condemning it. Heavy industry is segregated, but light industry isn't.
Also, if electric cars become a thing, you can at least hope that within 10-15 years, environmental damage from major roads will diminish.
The proponents of wind turbines seem to forget that wind turbines are huge industrial systems. Placing them all over the map in a populated territory in the name of nature sounds a bit like "we had to destroy the village in order to save it". Future generations may shake their heads on current placement of wind turbines just like we shake our heads on our forefathers placing iron smelting industry in the middle of cities.
I can see their appeal in shallow seas around North Germany, Denmark or England, where they can produce a lot of power from constant sea winds and be a bit out of sight and hearing, but people pushing them into Erzgebirge are damaging valuable places for a few megawatts of power.