I see what you’re getting at, calling out a No True Scotsman. It’s worth remembering that some people
aren’t actually Scotsmen.
SF is essentially a single party system. Everyone has to run Democrat, even the conservatives. It continues down to liberal hypocrisy in the citizenry, which mirrors the conservative hypocrisy. Every abortion is immoral except the one I need, everyone deserves affordable housing except in my neighborhood.
The end-to-end government in SF, which would include the state and federal, is not meaningfully progressive. It’s extremely progressive on visible, local issues. But it’s to such a point it’s absurd. This is how you end up with a very conservative tax system while petty property crime is de facto legal.