I forget where I saw this but there was a company that had set up what were basically "team offices" so teams that worked closely together each had their own closed room where they worked, so they could collaborate in their own manner.
Quiet when they needed it, loud when they needed it, and on their own schedule.
That seems like a good middle.