I don't think you are really grasping why, and in what contexts, "median" home prices are used and considered valid measurements and comparisons.
They are really valid for evaluating single time series data and comparisons between time series data.
They are somewhat useful for "cost of living" comparisons, but even within that context, a high quality analysis will consider what you get at the "median" price.
But, the headline writer at clickbaittimes, err, USAToday, will surmise that the surface level view you are undertaking is "good enough."
But the reality is that real people, in the real world, make employment/career decisions based on what they can afford at the salary offered in an area, and the very simple fact that you are very intent on ignoring is that the same money in Boulder will buy a *much* larger/nicer home than it will in the bay area. And real people a. notice that, and b. make decisions based on that.
Good comparisons of costs of living don't look at "median" home values, they look at the median "4 bedroom, 2 bath, single family home" that people think is appropriate for a family of 4. And in that comparison, SFO is a lot more expensive than Boulder.