While I do agree with your overall premise, having had offices at multiple roles over my career, it is a major improvement over cubicles and open office.
Having a space to work in complete, uninterrupted quiet is wonderful. The simple social signal of the door being opened or close implying availability to chat works great to balancing heads down time and chat with colleagues time. Have a white board of your own that you can stare at throughout the course of a project, that evolves with discussions has not be replicated yet either remote or in a shared space.
You can also get pretty wild with customizing an office for comfort. I used to know many people that brought their own lighting in, completely solving the problem of constant overhead fluorescence. And brewing your coffee the way you like it in your own space in the afternoon is very refreshing.
Even given all that I'm sure many people would still prefer remote work (I would at this point), but I can image a fairly large number of people that would be very interested in a set up like this. It also mean your home is completely work free again.