Noise isn't a problem. It's unpredictable noise or unwanted noise that's a problem. Or noise that cannot be controlled.
In IT, working in a deathly silent office is bugging. I need the background of fans spinning to "feel right", but I don't think it needs to be loud, or even immediately audible. And anything beeping will drive me to distraction as my brain is tuned to find that beeping thing and fix whatever the problem is.
But a tap dripping? Or headphones tizzing? Or someone tapping their foot or banging a door? Even a mouse clicking? That drives me mad. That's why the background hum is good - it washes them all out.
I work in an office with a technician. He's young, keen, not used to workplaces with lots of other young people.
We have a "swear jar" of sorts. It's for when he hums, whistles or breaks into song. Playing music, I've told him, is right out. Like others, I've worked in places with fed-in music and it drives me insane. I spent a year in an IT office with a badly-tuned radio locked to BBC Radio 1 and it drove me mad.
I work in schools, so some weeks/months of the year there is nobody around. All my speaker-sets go missing as the office and teaching staff use them to take advantage of the empty offices by having their music up louder than they'd ever be allowed while others are around.
Run an after-school event and all the kids want to plug themselves in while they work. I'm sure that's good for them but the noise leakage from their tiny in-ear things is immensely annoying and often means it's banned even through headphones (not just by me). Even on the school PC's, no apps, games or anything else that makes a sound and internal speakers are switched off - when you have 20 PCs in a room, that's just a cacophony of nightmares.
It's a matter of courtesy. Even if you NEED sound to concentrate, you need to understand that others NEED silence. If you can find a way to have your sound without interfering with their silence, they won't have a problem with you. But blanking out sound is immensely harder than drowning out silence. and there's a fascination with having music so loud that everyone can hear, even out of sound-insulating headphones. That's just unnecessary and rude.
And when you get into singing along, humming, drumming, tapping or anything else, I will break your fingers and shove them down your oesophagus. That's not necessary at all and does nothing but inflict your sounds on others that have already chosen not to listen to your music.
I own a couple of sets of headphones. At a reasonable price, set to a reasonable volume, you literally can't hear a thing from outside them. And I couldn't hear a thing outside when wearing them. So it's not impossible to cater for such tastes. But people don't do it. The problem is that there's no earplug or set of headphones that can provide silence in such a situation. The closest you get is bassy tinnitus coupled with heartbeat, blood-rush, swim-ear sounds, with the background slightly muted in the background.
So when you're on your own, out of earshot, do what you like. When there are others around who don't like sound you need to get a decent set of headphones and keep it to yourself. I know that means restraint in your personal tastes, but you also have to stop picking your nose, scratching your feet, farting, undressing, and all the other distasteful habits at that point too.
I will make one exception: With babies around, you should not be asked to be silent for them to sleep. All you're doing is breeding people like me who can't relax in silence by doing that. And a baby will sleep through ANYTHING. Babies will fall asleep outside in a noisy shopping centre, at a party, with a movie blaring, etc. *Sudden* noise might wake them but that's only more sudden and scary against the silent background than if you just all talked normally over the sleeping child and someone sneezed or whatever.
And if a baby wakes, it wakes. Nobody INTENDS to wake them. That's my one exception - talk normally around babies and even sleeping children. You're subconsciously teaching them to be able to cope with a noisy environment without actually disturbing them at all.
But otherwise? Shut the hell up or isolate your noise from me.