When I was in operations, having an open-ish war room with a few shared displays of monitors where everyone can talk was helpful during a crisis only. That is easily replicated with a good chat software like Slack, if the ops team needs to work around quieter groups. Outside of a crisis, the openness was only useful for gossiping. Of course, outside of a crisis OPs have a much more limited number of jobs because they exist to fix the crisis situations, so the extra chatter really helps the group cohesion under pressure.
I would suggest asking your teams to make formal recommendations as teams about their future work space. A command decision, no matter how well grounded in research, will devalue the needs of your people and lead to sub-optimal spaces. They are unique groups, and may not need to follow the "best" industrial patterns.
Also, don't let the managers overrun the conversation. Otherwise you will end up with spaces that make it easier to micromanage people rather than get work done. Panopticons, where management are in offices while workers are in highly exposed open spaces, lead to higher turn over every single time. You want spaces where people can work conveniently, not where managers can manage easily.
Closed areas for meetings, calling, and deep concentration. Open areas for side-by-side coding and colaboration.
Usually marketing and sales can work anywhere: give'em an open space. Also give them a closed place where they can call confidentially a client without developers/pm hear them.
Project managers are similar, put them near sales and development teams.
Devs need to remain focused for 1-2h runs, and might need to do pair programming or just get help. If you bring them an open space, gift them with deep concentration cabins, and/or meeting rooms for 2-3 people.
Sysadmins need something with a door to make some friction between the team and them. Otherwise people passing by will ask them anything possible. If you don't have such space they will migrate silently to the datacenter.
Data scientist need absolute silence. Closed spaces, rooms, etc will work. If the place is not quiet enough consider renting some space at the nearest churh and install wifi there (not kidding).
https://www.archdaily.com/884192/why-open-plan-offices-dont-...
Cal Newport also writes a lot about creative work, deep work, and how office layout influences productivity.
https://officesnapshots.com/2012/07/16/pixar-headquarters-an...
In short: I like modular, configurable workspaces, with lots of whiteboards.
For me personally I find that the temperature of the room/building is important. At my office people continually turn up the thermostat to 75-80F.
Aside from that giving employees enough room to turn around in their chair is decently important in my opinion . In my current setup (I call it the sweat shop setup) I'm not able to turn around or get out of my chair without bumping into my co-worker behind me.
Lastly - one thing that happened at my office was the installation of over-head speakers (think department store style) that constantly streamed Pandora. Please don't do that as it's annoying.
Things to consider beyond the obvious questions of cost or distraction/focus: knowledge sharing, mentoring of junior devs, and culture building. The environment you build will fall somewhere on a spectrum of open office, doored single offices, doored shared offices, or open offices with “pods.” Consider the tradeoffs of all these (and ask your employees for their input!) before making your decision.
I think it is valid to offer as a possible option to consider regarding the original question. But not with the label as “the best”.
Personally I like the option of working remote sometimes but I don’t feel productive when remote for most activities. I feel productive in my office. I also find value in the irl interaction with co-workers. But we also have offices with max 2 people (3 for interns). So there is already lots of privacy and quiet at the office.