For me, a little noise is the worst. A busy cafe with a constant level of noise is easy for me to tune out. If everyone is silent but like every 30s something happens: Someone coughs, a bag of snacks is rustled, a cardboard strap is opened. That's the worst.
I'm fine when the general level of noise is way up, because there's less for the brain to latch onto and get distracted by. I've churned out serious lines of code in a noisy cafe, but always churn out more when I'm at home: my noises, no distractions.
It's the human interaction though that drags me away from the work-from-home/work-in-a-cubicle lifestyle.
I find even quiet conversations in an open environment to be the worst of all distractions. The clacking of pens and the slurping of drinks in a library set my teeth on edge, forcing me to wear headphones, which means I may as well be outside with the rabble.
This is driven with money-saving in mind -- at least short term. Consider it is easier to lease space as a landlord if it is open space floorplan, and it is easier to deal with a 1-2 year temporary space as a startup, than actually pay to modify it.
They really should have collaborative AND personal spaces. Not a forced airport-like office setup.
What were they smoking when they designed those?