Imagine, in SimCity terms, if your Low-Density High-Wealth Residential citizens passed a ballot measure preventing you from building Medium-Density Residential zones, and you have the essential problem of SF and other regions in a nutshell.
People don't like density upgrades, and they fight against them tooth and nail. It's what we get for allowing density to be zoned locally, and it's something that other countries just don't even allow when it's bad enough that homelessness is a problem. "Your city block is being upgraded to a megatower, here's due payment for your home and you get first right of refusal on a free home in the megatower."
Be warned, though; once you become an established local, you are extremely vulnerable to falling prey to this exact behavior. I know several awesome people who finally made their wealth and bought a house in SF, and promptly turned into anti-density NIMBY folks - because they were afraid that they might not make a profit on their home, or because they liked their neighborhood, or whatever.