More on Stanford from another Stanford parent....
Slight correction on hotels/locations. The Courtyard Marriott is a few miles down El Camino Real from Stanford, not across the street. It looks very nice from the outside, I haven't been inside....
The ones that are closest are the Stanford Terrace Inn (on the south edge of campus and right next to Starbucks). The Sheraton and the Westin are down the block from campus on the other side of El Camino.
Fancy hotels are the Stanford Park, a mile north of campus and across the street from the shopping center, and the Garden Court in downtown PA. There are actually a lot of small hotels along El Camino in Palo Alto.
The kids seem to enjoy the most: California Pizza Kitchen and Cheesecake Factory, both in downtown Palo Alto. Also the Peninsula Creamery (great burgers and shakes) which has two locations--one in downtown PA, and one at the Shopping Center. And Max's Opera Cafe for extremely abundant food at the shopping center. Macarthur Park, in a historic building just at the edge of campus, is also fun--ribs, chicken, etc., but a bit on the dressy side.
The deli that justbaseball mentioned is actually in a small grocery store. It is "JJ & F market" on College Avenue, which is a block south of campus off El Camino. The Stanford baseball team members have sandwich accounts there for before games.
Sundance is okay and in fact is one of my favorites too--steaks, prime rib, seafood, primarily but the interior is dark and in summer it might be nicer to go to a place that is a bit more open and airy. Other fine restaurants include Il Fornaio (downtown), Spago (also downtown), and Spalti (on California Avenue). My favorite is St. Michael's Alley downtown(which was named most romantic restaurant in Palo Alto
). If you like sushi, try Miyake in downtown. I agree that Nola is very good, and different. And also thumbs up on the Old Pro.
California Avenue, which is about 1/2 mile south of campus off El Camino, also has Quizno's, Subway, Round Table Pizza, etc. for the guys. Also, another Starbucks and at least one Zagat-rated restaurant which is kind of hidden away near Quizno's called Bistro Elan.
The really great ethnic food (if you are not going to the City) can best be found in the next town south, Mountain View, on Castro Street.
The Cantor Arts Center at Stanford is a nice place to wander around if you're on campus with a little extra time to spare, and they have a very nice organic cafe in the museum that overlooks the Rodin Sculpture Garden. There is also a lot of outdoor art on campus.
For bleary early-morning people who need espresso drinks, the closest Starbucks is the one just at the south edge of campus on El Camino (corner of Stanford Avenue). Peet's is generally considered the best coffee place and it is across the street from campus in Town and Country Village (10-15 minute walk, 2 minute drive from Sunken Diamond). There is a Jamba Juice there, and there is also a JJ and a Peet's on campus in the Tressider Union (a fair distance from Sunken and the Peet's there has weird hours, I seldom find them open)....There is also a nice cafe in the Arrillaga Alumni Center, which is a beautiful new building on campus a couple of blocks from Sunken. (one thing to note about Stanford--the campus is very spread out and you pretty much need a car or bike to get around, although there is a free shuttle bus that crisscrosses campus and stops at the shopping center)
Also in Town and Country Village: Cold Stone Creamery (ice cream, kids love it); the Village Cheese House (awesomely decadent deli sandwiches); Rojoz (very good wraps and salads); Hobee's--nice family restaurant, VERY popular for Sunday brunch; and Douce France, authentic French bakery with wonderful pastries. And Long's Drugs for sundry stuff you forgot.