In a stark contrast, I think is Google's 111 8th Ave Port authority NYC building, its one of the best workplaces. All advantages of having a huge building (Bigger area than new Apple spaceship campus), while still being in an extremely vibrant and well connected neighborhood.
I work in said building and love it. Absolutely a top notch office in a top notch location. Unfortunately the historical circumstances of the building (see video below) make it pretty much one of a kind; there simply aren't any more buildings like this for other tech companies to use. And good luck trying to build a new building of this scale.
111 uses an open floor plan with conference rooms in the middle on most floors. Most desks are located near large windows and natural light, but they aren't really in offices if that's a big selling point for you.