I've lives a while in Seattle (childhood to 2010) and San Francisco 4 years ago to present. My take on it is that San Francisco isn't really significantly better or worse than comparable dynamic cities. It's got good cultural, social, and economic opportunities. But it's nothing super special, and it largely doesn't justify the cost unless you're getting paid a premium to live there (thus why it's dominated by higher paid workers mostly in tech).
I'm not so sure whether it's fair to say that this is the wealthy people deliberately imposing exclusory policies. It's mostly long time residents that are anti-development and favor nativist policies like rent control. Most of the tech workers I know want the city to build more housing and remove nativist policies. But some, like proposition 13, are enacted by the state and our ability to remove them is very limited.