After Covid, we went into the office one day a month and didn't really achieve anything additional at all, if anything those days were less productive due to the heavy socialising that went on.
In my current job, pan-European financial services organisation, I am the only person in my team in London, everyone else is in Brussels. I've never physically met most of them. The one day a week I'm required to spend in the London office is a complete waste of time and money and usually involves me sitting on Teams meetings all day as I very rarely need to interact with anyone else in London. It's my least productive day of the week.
I'm also not in a "mostly lone producer" role like developer, I'm a project/programme manager and my job is interacting with people all day.
I think it just depends if people are able to refocus their mind into a new way of doing things.