People have such high expectations of housing, they are pricing themselves out. I do live in a 60+ year old, 1400 sf house, but that doesn't bother me.
You do not deserve to live in San Francisco. Sorry.
What's probably a bit more toxic about your attitude is the implied belief that you deserve "better" than everywhere else in the US, that San Francisco is "yours* and not anyone else's.
And not for nothing, but I do have children (two) and am entirely capable of empathizing with others.