You used "some" in a lot of your sentences and that sums it up perfectly. Some people work better at home, some people work better in an office. Some jobs require more collaboration than others. I am the first to admit that meetings are usually a tad more productive in person but arbitrary "two days at office" policies make no sense, especially if there is not a policy where everybody has to go in on the same day(s).

Office mandates are dumb and it should be left up to individual team leaders.