My ideal is somewhere in the middle. I don't necessarily need a private office, but a shared space with a small team. This way, I'm privy to all conversations relevant to me. Knowing what's going on often trumps the productivity gains of a quiet work environment.

The issue is large open offices where I'm also privy to all the other distractions from other teams that aren't relevant to me.