It's just not worth it. I went to an open house this weekend to see a 800 sq ft 2b/1ba in Castro area for "only" 1 million and the ceilings were (no joke) ~6' high!
But that same $1.5M home is probably a 1920's floor plan (one bathroom, no storage, tiny bathroom) and hasn't been updated in decades.
If you want what most of the rest of the country deems a middle class house, you're looking at $2.0M+ unless you're living in a neighborhood with shootings.