Anecdotally every office I see these days is filled with noise and open space.
When I started it was only myself and the one accountant, and near the end of my time there it was just myself and another dev (that got hired shortly after I started) since the accountant got their own office.
At my 2nd role, it was terrible. The devs were smushed in-between the Accounting and HR department, which made it absolute hell to talk to my co-workers about issues and to actually do some development without interruption. Oh, and it was strictly no WFH/Hybrid. 2hr on public transport one way, every day.
Now I work for the government and it's lovely being able to do hybrid, and the office is actually somewhat quiet since the whole floor is for the developers.
It was a large building and only about 20 employees, so pretty much everyone with a computer got their own private office (like 12 of the people, some people worked on printing machines or the shipping and receiving area).
Haven't had that since. I've worked in rooms with just 1-2 other people since, and those were startups. Any corporations I've worked at have been wide open rooms with lots of chatter and distractions, and probably contributed to me developing tinnitus (especially since I had music on to drown out 5+ conversations happening around me at once so I could concentrate).
Now, I have a large private office with an amazing view and has an incredibly short commute.
Like others have said, if you want a private space, it's better to work from home anyway.