The best office I ever worked in was an open office... with an open remote work policy. On any given day, only 15-30% of the office would be in; meaning while the office was "open", it was also usually empty and quiet.
People came in when they had in-person meetings, and teams generally fell into a loose schedule to come in on the same days 1-2 times per week.
I thought it provided a good balance; the company need to have a huge space to give people private offices etc, and it was quiet even if someone nearby was on a call.