Do I think I got more done in the office? Undoubtably.
Do I cherish the fact that I have been able to be home with my young children? More than anything.
I did not have children pre-pandemic, and was anxious to return to office. When our office did reopen I was there most days. But then my wife and I had children and I have not willingly worked from the office since.
I get less done in the office. I'm orders of magnitude more productive at home. So my opinion is formed on that basis.
Theres absolutely no need to force a single option. Where I work we went for an approach of "the office is there, its open, you've got a key, if you want to use it, use it. If you don't then dont."
That as far as I can see is the fairest approach. Those that prefer being in the office can do so, those that prefer being at home can do so. Theres no loser there, except perhaps anyone with a bizarre view of "well I'm in the office so you should be too" but those people are crazy nutjobs.
It presents a difficult problem b/c both sides have a point: without nearly everyone committing to being in the office (at least on certain days) or full-time remote, you lose the full value of either setup.
I honestly don't know what the long-term solution is outside of a lot of variation and individual/team/company choice. Within a given company any change should probably be gradual (e.g. start only hiring in geographic areas around your offices if you eventually want to go full/mostly onsite, offer to pay relocation to people who move close to an office). Senior execs love knee-jerk, emotional decisions to impress shareholders though so I doubt it will work out that way.
If management make me come into the office and expect me to work with people who are working remotely or from a different office, I will bitch about it.
I firmly believe that a knowledge worker can't produce anything of any quality for eight hours a day, fives days a week. When I was in office I just spent more time pretending to be busy, and I think that's what management wants to see - the productivity pantomime.