I say they are obsolete for programmers, video editors, graphic designers, anyone whose job consists of doing things on a computer.
I've worked on remote engineering teams for companies that have their non-engineering workforce go to an office for the last 6 years.
There's tradeoffs. Remote is much better for some things and in the same physical office everyday is much better for certain things.
There's a ton of blog posts that have been on HN over the years that go into the details of the pro and cons.
But anyone telling you it better one way or another in general is full of it. All depends on the details.