In the real world you'll have to compromise on some of your priorities.
No compromise needed on those points, the compromise is living in a smaller apartment, but it’s okay since now my backyard is Golden Gate Park.
More traffic, fewer families, faster pace of life, etc.
The Bay Area has its pros and cons.
So yes I compromise on apartment/house size because I value walkability, local activity density, and year round running. Guess that makes me part of the “very narrow demographic” in USA.