Honestly, it's not like hams are sitting on any significant amount of really prime RF real estate. I think it's a worthwhile hobby, (though I've never really been involved. I used to monitor the long-range ham bands on my shortwave, but found it amusing that people from across the world, from different countries and cultures were contacting each other, and all they ever talked about were their radios!) ;) It also keeps a portion of the radio spectrum "public" which I think is a good thing.
I'm on the side of preemption of local rules, myself, like with TV antennas and satellite dishes. I'll give you reasonable accommodation (disguising the equipment to blend in to local surroundings,) height size restrictions (which really just lead to more installations of smaller equipment) and a historic exemption (which, one could argue, would cover half of San Francisco anyway!) to keep them out of Amish country, etc. but that's about it. If a commercial-zoned building owner wants to lease roof space to a wireless company, so be it. Cell towers, like power lines and telephone poles are part of 21st century life. Embrace them as the thing of tech beauty they are! ;)