Even within the Larger Bay Area there is plenty of smaller cities with a well developed and prolific downtowns that have startups, retail, supermarkets, bars and restaurants all within walking distance of a rail system connecting you to SF:
Mountain View, Oakland, Redwood City or where I live - San Mateo.
My family and I have been a 1-car household for more than a decade and mostly walk everywhere including a train station for a 25min ride to SF