Of course this may not all be attributable to high cost of living, taking a look at the BLS page on RN wages across the country, high RN salaries and states with strong union laws seem to run hand in hand.
I can't stand dual income. I can't stand commutes now, either. That's why I left the bay area last year.
San Jose, East Palo Alto, parts of Redwood City, Pacifica, etc...
The parts of those places you listed that I can (could) afford, I wouldn't live due to various problems like crime, neglect, etc. They aren't really a good choice for normal, simple people like me.
I think most people aren't there by choice, but by necessity. I'd much rather have the people watching my kids in a spot by choice than necessity. You may ask why that would matter, but given a little thought it'll matter you as well.
So this means a nurse and dental hygienist couple earns a family income of about 230K a year. They probably aren't buying in palo alto, but they aren't priced out of other nice suburbs. The sad thing is that most of the high salary is dumped into the housing market (and child care, which can be 25k per kid, which becomes a huge issue when you need two incomes). I guess it all depends on how much you love living here (if you have the right setup, it actually is pretty incredible, but you truly do pay).
It's not easy, but you don't have to scratch your head and wonder "who are these people". A two income middle class couple is in striking distance.