I live in a large city and the noise here isn't very bad.
I do hear traffic noise during the obvious times, weekday mornings and afternoons - rush hour
I hear sirens a lot, but that's only because there is a hospital across the street from my house.
I rarely hear gunshots - but come to think of it, I couldn't tell you what a gunshot actually sounds like
Those of us who have no exposure to firearms don't really know what a gunshot sounds like - it's nothing like how it sounds in movies
Construction noise is at a minimum.......at least, near my house.
I hear the occasional jet overhead, because my house is along a flight path to the airport, and I hear the occasional helicopter and drone,
My least favorite "noise pollution" is the buzzing of the landscaper's leaf blowers,
You would think that an advanced civilization could develop a quiet or even a silent leaf blower
You have to consider people who work at night, they are sleeping during the day,
Some businesses require more controlled exterior noises, such as a recording studio.
Can you imagine going to record the best vocal track ever, and all of a sudden, from outside you hear "BUZZZZZZZZZZZZZZZZZZZZZZ!!"......studio microphones WILL pick that up.....
As far as "affecting one's consciousness over time", I think that, in regards to my neighborhood, we adapt
we get "ear blind" to it after some time.
Humans have used our skills at adapting to survive and flourish.
I would prefer peace and quiet, and the sounds of nature.
That might get boring after a while.