I don't understand how the bay area could even handle more people. I think you'd have to increase the number of lanes on the 101, 280, 237, 85 by at least 4 more to make it work with the current population.
Or you can massively increase transportation capacity, not just with roads but (more effectively) with trains and subways and other forms of fast, efficient public transportation.
Of course none of this will ever happen, SFBA residents and government will continue to exclusively focus on slaughtering their golden geese until they all gone.