What this seems to be leaving out is the lack of much of an escape valve in the Bay Area. Where there’s density, there could be more - with zoning changes and years of red tape. Where there’s little density, geography is against much of anything. You have serious hills/mountains, the bay and the ocean dividing things up. Where there’s land with little or no housing, there’s no drinking water and/or regulations against building and/or those areas aren’t very well connected.
Atlanta seems to be one gigantic sprawl that steadily transitions from relatively low density urban to suburban. If you can’t afford/find housing in the metro proper, just go a few miles further out.