This is a difficult one and in all honesty its not a "one solution, fits all" scenario.
I had a role where I had to go into work solely because other staff members wanted to be in and apparently their needs trumped mine. Basically they were single and lived on their own and living and working in a small place without seeing anyone, was affecting their mental health so they wanted to attend the office. It was the first job for some after leaving uni and they had moved areas for the role so had no friends here. I on the other hand was near the end rather than beginning of my career and lived in my home town with my husband. I was annoyed at my right to choose being taken from me and wanted to be at least hybrid.
I then got a hybrid job, but on the days I was "in office" I wasn't actually in my office, I was on site visits. I felt my ability to learn form others was vastly diminished and I was surprised at how much I missed the background information that I subliminally picked up when simply sitting with my team in an office. I also found it impacted the social aspects of work, i.e. the unplanned lunch outings or drinks after work. The reduced desk capacity meant the entire team couldn't be in on the same day and I realised it was taking me longer to form the personal relationships I normally achieved with ease when office based.
And now I have a new contract and I am totally home based and my team are spread around the UK. The times I can work are very flexible and it really alleviates my caring responsibilities as I can work from anywhere and at the times best for me. Its everything I wanted....but.. there are definite down sides.
The social elements of work, which I have thrived on for years are none existent but I am saving money hand over fist, no travelling expenses, no impromptu lunch time outings with colleagues for a drink, shopping or meal. Its fantastic, but boring as hell. But it has also stunted my learning ability and awareness of what is going on in the organisation outside my role that may actually impact me at some stage.
I also find that when you are not front and facing certain people, they dodge their responsibilities and its hard to pin them down. Also the different hours people work from home, tends to be a problem if you need to connect urgently.
I have also had a colleague who (without telling work) took himself off on holiday with his mates without requesting leave (you can work from anywhere), taking with him his work laptop and caused us major issues as he just wasn't responding and his excuse was the wi-fi was problematic...he could only use it in the hotel reception! So it is open to abuse.
For me, hybrid is the best solution but I have some colleagues who are simply not trustworthy on their own and its people like them that spoil it for others.