SF in particular is wild. There are so many people who oppose any and all new housing because "it isn't affordable", as if just not constructing anything, ever, will let anyone afford anything.
To me it feels much more like just a significant cadre who resist any change, of any kind, for any reason, who can ignore the personal side effects because of Prop 13 and because their family bought a house in the 80s and they don't give a shit about anyone else who wants or has to live in the city.
They get this anyway, it's just unrealized capital gains.