The most effective mix for me is going into the office on Monday, and getting all of the meetings and planning and face-to-face busywork out of the way, and then working from home the rest of the week. It's easily 2-3X as productive, and I'm just so much happier.
As with anything. YMMV. I've never been an ambitious person though, and my job to me is just a 'do what is needed, and no more' type of thing. I'm never out there trying to network or dig up leads on new opportunities either though, so if I wanted to do those things or were more ambitious I guess I could see the appeal of going into the office.
We (my wife and I) do get out quite a bit though, although we're eachother's best friend so we're not out socializing with out couples in our off time (thankfully).
Total conjecture but the people who I have seen struggle with WFH are the same people who don't have a social group outside of work, so WFH ends up meaning no social life and they become very lonely and isolated as a result.
For people who do have that social group, they tend to want to get the work done as quickly and efficiently as possible so that they can then spend time with their family and friends, ie the people they want to be around, not the people they have to be around to make money for their employer => themselves.
With family and friends you can talk about life and have fun. With coworkers, often you talk about work or things indirectly connected to work...