Is the San Francisco Bay Area sprawling?

It's not nearly as sprawling as, say, Los Angeles or Atlanta. You can look up the population of each city in the US Census Bureau's data. That should give you some idea.