Your analysis makes a lot of sense.
In my view, the best balance between working remotely and at the office is to work remotely on most days while showing up at the office regularly to maintain a connection between team members. Forcing people to work at the office every single day is a massive waste of everyone's money and time including that of the employer.