It all depends on the rest of the company. It's a big difference if the whole team + management are remote, and there are established practices to work that way, vs most of the team is not remote, and just a few individuals are. I find the last part harder. Not impossible, but just harder for everyone.
During the pandemic a lot of in-office teams were forced to adapt quickly, and that doesn't always work well; it takes time to build a culture around that and some people just don't work well that way. So not too surprised that after sometime it was declared a "failure" and everyone is forced to RTO.
For me, I was never in the office to start with, so there is nothing to "return to". I know I am taking a pay cut picking choosing, but I picked to spend more time with my family instead of commuting. It helps the environment, too. But being with my family was my top priority.