The houses that are close enough to town centers to live that way are highly prized and unaffordable to almost everyone. By removing the possibility of driving to a town center like Mountain View or Palo Alto, you are actually disadvantaging people who can't afford to live close enough to casually bike to Whole Foods on a Sunday morning.
Look, this is a complicated issue. It's hard to get there from here because a lot of things have to change at once; there's a chicken and egg effect here. I can imagine a different Palo Alto or Mountain View, but I can't imagine how neighborhoods could change without drastic social upheaval. And if I have to handicap the NIMBY power of well-to-do homeowners to keep your plans from taking effect, I'm going to bet on them. Not because they're better, but because they're likely to win.