Unlike the main office, most people don't have to choose between commuting from SF or living in Mountain View, because Venice/Santa Monica is actually a nice area to live in :). Naturally, the breadth of projects is not as big as in Mountain View, but there's a number of exciting things happening here (computer vision, quantum AI etc).
I bet you have a few surfers there! I'd kill to work next to the beach. Nothing beats a good early morning surf session. (Figuratively, of course)
I didn't work out of any remote office full-time, but I visited seven satellite offices during my time there (nine if you count YouTube/SF). They were all unique and awesome.
Also, at least in my case, I don't get that "satellite office" feeling from the work I'm doing. The people I need to talk to most all sit within Nerf gun range.
I also work at the chicago office and we work on interesting and hard problems that keep me engaged. We are a remote office but it doesn't really feel like that's a hindrance.
There are challenges to being remote obviously but I don't feel like I'm missing out on anything critical.
As for actual work, projects seem randomly distributed, with some weight towards Mountain View since it's so much bigger than the other offices.
I've heard great things about the New York offices as well as the Zurich, Tokyo, and London offices though!
Personally, I've talked to Googlers all over the world and there seems to be a consistency in openness and passion.