Palo Alto and Mountain View have real places; the rest is pretty much all miserable sprawl. I miss working in downtown Palo Alto.
Likewise Sunnyvale and Santa Clara are quite anemic, but Los Gatos, Saratoga and even Los Altos aren't bad. MV and PA are great places to dine.
Cupertino is the only town I've worked in that never had a downtown.
Sunnyvale didn't really until they started building a clone of Santana Row that went belly up with the housing crash. Well I guess Historic Murphy Avenue sort of counted.
I can't even remember how many days I got to work when the sun was coming up and left as it was setting, or after it set. It was like a perpetual winter.