I think we have a pretty good intermediate where I work: closed offices of 3-4 people, with open collaborative workspaces available to anyone without needing to book them.
It's gov't though, which tends to be neither an intellectual monoculture, nor a major hub for new creative ideas. It's somewhere between industry and academia, but after 8 years I'm still not sure precisely where it is on that workplace spectrum.
Closed office of 2/3/4 people is indeed what I found the best (after home office). Alone in an office, I waste my time and get nothing done (strangely, it is not the case at home); above 4 people, it is a mess, I cannot concentrate and I labour.
It's gov't though, which tends to be neither an intellectual monoculture, nor a major hub for new creative ideas. It's somewhere between industry and academia, but after 8 years I'm still not sure precisely where it is on that workplace spectrum.