This is why I'm going to move out to the country. Even though I don't plan on having a tower ever myself, and if I did, it wouldn't probably be higher than 75 feet, and it would probably be used as the apex for wire antennas. I've seen a lot of good "beam" installations, but I've also seen ones where they move around a lot in a good windstorm-too much for my liking.
Where I currently live, I use wires, and any "verticals" I have are in the back, so you can't see them from the front.
I can get why people wouldn't want a neighbor with a tower way in the air, especially if it were to fall over it would possibly land in your neighbors yards. That to me is a bit much...
I prefer wires myself for HF. I mean don't get me wrong a beam is nice, but to me if I was ever going to do that, I'd invest in having it professionally done. Sure I could do it safely, but I don't think I'd trust myself to do that. Especially if it could affect my neighbors if I miscalculate or do something wrong and it decides to come down in weather.
I haven't had any complaints where I am so far but I'm not in a HOA, and where my stuff is mounted, if it were to come off the house, it'll land in my backyard so I won't be affecting anyone outside of my fenceline. I also don't run a lot of power on HF which is what would affect my neighbors interference wise. I also tune my antennas, so the chances of that are lower, of course. Plus with the advent of digital TV, I shouldn't "come over" anyone anyway, honestly.
There are a lot of uses for towers and such, but as far as I'm concerned there are plenty of people doing that, so they can be out there to run nets, chase DX for awards, etc. I think a contact is much better earned using 100 watts and a well tuned wire. It means a lot more to me than pointing an antenna at it and using 1500 watts to get it. To me that's like shooting fish in a barrel, so I do it differently. I'm also not in it for the wallpaper. But that's just me. Fair compromise is fine with me. And honestly, if someone thinks they should have the right to put up a tower over 50 feet in a subdivision, they shouldn't be surprised their non-ham neighbors might have a issue with it, especially in the cookie cutter neighborhoods they have nowadays. People in those obviously want everyone to look the same and dress the same, basically. I get the angst, in a way. There are risks associated with that kind of a deal because done wrongly it's going to affect your neighbors more than just being a visual issue.
Even out in the country I won't be putting stuff on the front of the house, though. I've always put stuff on the back side where its less visible. I want to enjoy my hobby, sure, but I don't see the need to advertise it to everyone either. Besides, I do that well enough with the 5 antennas on my vehicle anyway. (I'm not joking).