There's a balance that needs to be struck. Team spaces probably make the most sense.
we had real offices and my coworker and I cut a huge window sized hole in the drywall
Yeah, that's not an open office.
A workspace shared between two people, or even three or four, is a little different from an open office. I've worked in rooms I shared with small groups and can definitely see the benefits. After a certain point, like maybe ten or twelve, I think it becomes too distracting.
Logistically it seems unlikely open offices will go away, software heavy business can’t just spread their workforce over 3x the space, especially in dense urban areas. Better to come up with novel solutions for deep work, like dedicated open area library/dark dungeon rooms.