The solution to this conundrum is to give people a choice.
Except that if most choose full time remote, then those who favour hybrid (like me) or RTO have their choice made for them wrt collaboration and the other reasons given in the parent comment, so unfortunately, no, that's not really a solution.
A bunch of reluctantly-at-the-office coworkers isn't going to be the collaboration utopia you're hoping for. If you end up with an empty office because everyone chose WFH, switch companies.
Eventually things will balance out, with people in companies that have the right balance for them.
Except that if most choose full time remote, then those who favour hybrid (like me) or RTO have their choice made for them wrt collaboration and the other reasons given in the parent comment, so unfortunately, no, that's not really a solution.