Somewhere in the middle of South Bay Suburbs and taking an elevator to grocery store would be ideal. Somewhat like European cities.
I'm curious what you feel the cons are. I've lived in essentially this format now in two cities in two different continents, for a while overall, and I haven't really noticed downsides, except that sometimes I would need to cross the street to go to a different "grocery store" because the one I lived above didn't stock something, luckily the bodegas/farmers markets/produce stands nearby did.
All the cons about living in an apartment/condo vs a single family home (which all basically boil down to a reduction in one's personal freedom on/in their own home).
I personally grew up in a spacious single family home, but love my current life in an apartment. I don't feel it restricts my personal freedom at all, plus I get the perks of living in a vibrant area.