There are advantages and disadvantages to all three arrangements. It all depends on your own personality, your employer, other employees (especially direct team members), the nature of the role, distance/cost of travel and how well you can compensate for the lack of face-to-face communication in your personal life. I'm sure that if you're neurodivergent or even just introverted and don't socialise very well in person or have a limited social battery, then a completely remote role where your communication is mainly through messaging or voice calls will be a good arrangement. However, you could also argue that by avoiding the things you find difficult or don't enjoy, you'll just fall further behind your peers. While WFH means you'll avoid certain distractions, you'll also need to be much more disciplined, as many people fall into bad habits when no one is watching, getting out of bed 5 mins before work, taking longer breaks, doing chores, playing games, etc. when there's actually work to be done (fair enough if it's genuine down time). It's easy to think that everything should be based purely on performance, but as we all know, that's not how business works.
I've been fully remote for years now, only in office a few days a year as they moved HO further away. It was great to start with, but for me, and discussions I've had with friends who've done the same, it wears you down over the years, unless you're really happy being a bit of a hermit (this forum definitely has a bias in that direction). I have a fantastic home office, a family and socialise with friends on a weekly basis, go for walks before, during and after work, but the separation between home and work just isn't there anymore and no, I don't work outside my contracted hours. Variety is the spice of life, as they say, and for me at least, working completely remotely really limits any kind of variety in my day-to-day life. The days, weeks and even months now just seem to blur into one.
Of everyone I know personally, I'm the only one who's still fully remote. Everyone else has either been forced back into the office for a few days a week or chosen to go back to hybrid, and everyone seems happier for it, despite some initial reluctance from some of those forced back. I'm sure there will be many cases of those at the other end of the spectrum who refused to go back in, handed in their notice and found another fully remote position. Different strokes for different folks! I don't agree, however, with lumping people into categories and suggesting that those who want to be in the office or on-site tend to be worse communicators etc. It's much more nuanced than that, and black and white thinking should be avoided.