For me, when I'm able to concentrate, the background noise is irrelevant. I simply do not hear it.
As much as I love the mountains and forests, I've come to realise that I like the idea of solitude a lot more than the reality of it. And so I find myself living in large cities, constantly seeking noise because it's the only way I can find peace.
White noise, and ambient "study" music is great -- it's like a null placeholder, I can focus and I remember hearing nothing instead of hearing silence.
I have taken the quiet attitude home as well. I used to have the radio or TV on all day long when I was working on my computer. Now I turn everything off when I work at home.
Then again, that's focussed noise where I can easily pick out entire conversations. By contract, the coffee shop I'm in right now is full of a wild cacophony. So much noise that none of it forms a coherent picture. This is trivial to ignore.
In the end it probably comes down mostly to what you're willing to make work for you. I find a mostly silent room maddening enough that I'm unlikely to ever give it a try.
The office manager ruled with an iron fist, fortunately, and she really didn't care if someone didn't like her, so these folks got the boot. She saved that quiet room, as far as I'm concerned.
A crowded open plan office, with interesting and relevant conversations going on all around me, is detrimental to my productivity.
Most days I spend my entire productive workday in a coffee shop across campus, precisely because it is loud and busy. Only with the surrounding noise can I avoid being distracted by specific things. The environment is so noisy that it allows me to ignore to entirely.