But it really depends on what your job/task is.
And how well designed the open plan area is: Break-out spaces, individual rooms for when someone needs to focus, have extensive telephone calls especially of a confidential nature, plenty of meeting rooms, cubicles (I hate cubicles, but that's me, some people like them). And plenty of natural light.
And if someone wants to work remotely, that's good. You're not me, and then I appreciate doing this sometimes. A lot of people prefer to not work remotely because of the work-life divide an office space benefits. And some enjoy the social environment.
I absolutely cannot work listening to music but am fine with osmosis of office chatter; make sure the printer's in a printer room, putting it on the floor is a special form of hell. And have a pantry for eating, I quite like the taste of aged fish but don't want to smell it.
In my experience hot-desking does not work. The benefit of people sitting together is there's a work-flow happening. People that need to talk to each other can. In hot-desking that all breaks down so what's the point at all other than when the whole office are individual contributors and office layout is irrelevant - many people have a relationship even with the plant that sits next to them.
Not everyone's the same. Provide options. It's a team effort. What works for the team as a whole? Measure what the team does, analyse it, reflect.