I think the shape of the building matters most.
I don't disagree that housing would be a good addition. But it's not going to be a magic bullet without flaws.
People used to act like worker bees following the queen, but now it's more complicated, and some of the queens have moved.
If in-office white collar work collapses totally, I'd expect to see a sudden drop in housing prices as older people who were only living in the city to save on a commute rush out, followed by a delayed correction of people currently living outside of cities because they can't afford them moving in. Prices would likely remain greater than suburbia, but maybe closer to the halfway mark between current city/suburb rent costs.
The cities that will be hit hard are the "cities"/glorified suburbs that litter the rest of the Bay Area. They're too expensive to for just the weather, they don't have the attractions of urban life, and basically the only reason to live in, say, Fremont, today is because it cuts your commute in half relative to living on the other side of the hills.
It would be an attractive place to live but for the random stabbings, used needles, and human feces.
The thing is, for each person there willingly, it seemed like there were 10 people just moving or commuting in for work. It was assumed by default that you don't live there or at least haven't been there for long.