There's not much going on in Cupertino. Palo Alto is a much nicer place to live. It's also much more expensive.
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).
Mountain View is much better than Cupertino, so long as you are relatively close to Castro St. Highly recommended if you want to live in that area and don't want to pay Palo Alto prices.