Quit my last job over being asked in once a week. It was the commute rather than the office that I really wanted to avoid but it was also an awful open plan hotdesk office for a company of hundreds of people I didn’t know or care about.
New role is office based but I don’t need to drive or take public transport and teams have their own rooms to work in. Much smaller company too, under 30 people. Banter is far better here and that helps quite a bit.
Most of my managers have been the second type, although how effective they are at it has varied a lot. Some are very passive and that has been good and bad, being left alone is great when things are going well. But when you need help they are useless.
The best have been the ones that know a decent amount about the job, they can either help you directly or know exactly where to point you for it. That or they understand the pain and you can both cry together for 4 days with a SQL database and increasingly vague error messages.