Fair. The point wasn't to contrast an ideal situation with a horrible one, just that you get far more house and space for your money. If you have a wife and kids and a busy career, you really don't want a 2 BR, 1Ba fixer upper. Something with room for a whole family will cost you at least $1.5M, probably closer to $2M. Either that or you're looking at a super long commute and even more car time than before.
Neither of these situations is ideal. Fittingly, both of them are the fault of NIMBYs.
I wouldn't want to move to SF. Walkable or not, there's an app that literally tracks where there's poop on the street, and I hear it's quite active. Doesn't sound like OP has a choice though. I have no input on locums rates, but based on what's been said here and what you can find on Transparent California (and assuming most community physicians make more than UCSF profs) it seems like employed does significantly better.