The Google New York offices follow exactly the model that you are suggesting.
http://www.bizjournals.com/sanjose/news/2014/10/23/google-se...
- First, the Pac Shores offices that Google acquired is in Redwood City, not Redwood shores, which is further to the north. It's not a 'continuation' of their campus but an entirely new campus.
- Second, Pac Shores was built in the middle of an industrially zoned area on a port. The massive salt ponds separating Pac Shores from RWC have had different proposals to further urbanize the area but they've been repeatedly shot down. The area is developing, give it time.
- Lastly, there are bicycle, walking paths, and caltrain shuttles going into downtown RWC from Pac shores, so it's easily accessible to the public library or a coffee shop if you want to go (I recommend Bliss coffee).
I think you're talking about the Mountain View campus and I agree it seems superficially to be an example of what you're talking about... I imagine with the benefit of hindsight and with modern (post 2000s :) sensibilities in mind both Google and Facebook would have tilted more heavily towards building up their SF presences back when that would have still been plausible/affordable.
However the parking restrictions are actually enforced by municipal regulation; I believe Google and many other companies (including my previous employer, VMware) would prefer to build campuses with much less parking but they are required to have a certain ratio of parking spaces to employees due to these antiquated regulations.
Meanwhile the other Google campuses are in fact located in large cities, though I believe transit access (Seattle?) is still an issue. One of the main reasons I choose to live in New York and work at the New York office is because I am a huge fan of the set up here where the office is centrally located and highly transit accessible.