Mountain View is affordable (compared to both Cupertino and Palo Alto, but unfortunately not to the rest of San Jose) - there's a great deal of good restaurants, it's a major Caltrain station (for a trip to the city).
It also escapes most of the suburban cliches (there's independent grocery stories, fewer chain stores -- other than the Walmart/Target area near San Antonio).