I agree it's not a black-and-white problem, but I don't fully agree with your statement about collaboration.

I am a senior software developer who was entirely against working from home until 2020.
Now, I can't imagine ever returning to working on-premise without losing a lot of productivity and most of my motivation.

I am absolutely for meeting the people I work with in person occasionally, though.
But we barely do any productive work at these meetings.
We usually have workshops or something similar, but for me, it is more about socializing with people than really getting anything done.
In my experience, some people are tough in online meetings, but they are suddenly the nicest if you meet them in person.

However, one of the aspects that has improved the most for me since Covid was collaboration, as strange as this may sound.

Before, we were all sitting in an ample open office space. If you wanted to talk to anyone, you walked to them and spoke directly with them.
Some had the rule that wearing their headsets meant they were focused on a topic and did not want to be distracted for that time.
That did not always work well because some people forgot this rule (strangely, these were very often the same sales guys), the developers forgot to put on their headsets, or they forgot to put them down after they were available again so often, that you just had to ask them anyway if you ever wanted to get your answer.

Also, we could not work in larger groups without getting into one of the meeting rooms, which were always in high demand.
Then there was the simple factor of different people having their own issues.
There are these guys with questionable hygiene, different preferences about temperature, the ones who don't like being too close to other people (social anxiety, I think), or people like me, who have awful hearing if there are too many people talking at the same time.
And working on the same codebase was horrible.
One person had to connect their computer to the meeting room display and either do all the typing or we had to take turns.
And that was if we had a room with a display...
If we didn't have a meeting room or one with a display, we all tried to somehow stand behind one person typing.
If that was in the "open office space," it also often annoyed people around us because of our constant speaking.

When we started working from home, all these problems suddenly went away.
We could meet online, connect our IDEs (and/or have one person share the screen), and everyone could sit in their own environment.
We often had group calls open the whole day, and most of the team was permanently in them. Some were muted, and you only heard the keyboard clicking from others.
If someone had a question, they just asked away, and anyone could answer.
If we needed to ask someone else, we just pinged them. They joined the meeting room as soon as they could and left after we cleared whatever we had to clear with them.

I don't work at that company anymore and am now self-employed.
However, I have a colleague with whom I talk about four hours a day via online calls since we work together on almost all of our projects.
Apart from that, it still works with our clients as before. If we need anyone, we ping them to ask if they have time.
This usually results in an immediate call or only up to a few hours later.

But we don't have to search for a meeting room or annoy other colleagues with our "constant talking."
Collaboration is now basically unlimited, where it was a struggle before.
The next in-person meeting with one of our customers is at the end of this month.
It will be an ~ eight-hour commute for me (each way), and I expect it to be as unproductive as the last in-person meetings.
But we see the people in person and have some human-to-human interactions, which is nice and helps improve the relationships with the people we're working with.