It’s possible that you just have an extremely left-wing view of what it means to be progressive, such that people who identify a s progressive to you and who would be called progressive by most Americans appear conservative to you. This is definitely the case with Republicans who call an insufficiently conservative Republican a “RINO” or “Republican In Name Only” (although the Trump wing which isn’t conservative has colored it to refer to Republicans which aren’t sufficiently extremist).

It’s also possible that SF tried more progressive policies, but found they didn’t work in certain cases (for example, the recent DA recall). Note that I’m not trying to litigate whether conservative policies would work better than progressive policies or any such thing.