Examples of Hell Is That Noise from Literature, where the sound itself terrifies the characters. Good thing we can’t hear it!
In Deltora Quest, the Wenn make a hideous racket to incapacitate anyone who enters their territory, so they can be paralyzed and eaten by the Wennbar, a monster that controls the Wenn. The Forests of Silence (ironically) are not pleasant places. Also the Four Sisters: the main characters begin to hear the first Sister to be destroyed, only to realize that they've been hearing the same sound their entire lives, and didn't even think of it as sound.
In the Discworld book Moving Pictures there is an instrument called a resograph ("thingness-writer"), which measures disturbances in the fabric of reality. It drops a small lead ball in the direction of the disturbance, which "... in severe cases may exceed —plib— two pellets —plib— during the course —plib— of —plib— one —plib— month". Or to put it in other words...
In the Dresden Files novel Changes, Harry fights a vampire-summoned Mayan primeval monster, a complete Implacable Man called the Ik'k'kuo. Harry notes that its heartbeat is incredibly loud... and when you are in a completely dark building, an increasingly loud thump-thump is not what you want to hear.
Somewhat undercut when it makes a different sound that Dresden refers to as "that teakettle thing."
In John Dies at the End, the sound of Korrok's otherworldly worm minions is described as "... fifty thousand men trapped on a desert island, deprived of food and water and sex but somehow kept alive for fifty thousand years. Then, after they've been tormented a hundred steps beyond insanity, tortured past self-mutilation and cannibalism, somebody drops off a sculpture of a naked woman made of T-bone steaks. If you could then capture the sound of them simultaneously fucking and eating and tearing her to shreds and broadcast it to the center of your skull at ten thousand watts, it would still sound absolutely nothing like what I heard."
In Michael Crichton's Jurassic Park, the T-Rex's roar, when first heard by the characters, is described as a horrifying, unbearable scream from another world. A character wets his pants while hearing it.
The sound the Dementors make is described as cold enough to freeze your soul. (The kiss will devour it)
In the Ravirn novels by Kelly McCullough, Eris' laugh is frequently described by Ravirn also known as Raven as sounding like glass breaking.
Dean Koontz's Phantoms will often include the descriptions of mundane sounds to help ratchet the tension, especially after a character has discovered a body. This culminates later on when someone picks up the phone and starts hearing various mundane animal noises, which slowly turn into the sound of thousands of people screaming in hellish agony.
The heartbeat from Edgar Allan Poe's "The Tell-Tale Heart” drives the narrator insane.
The trope is inverted in The Screwtape Letters. The letters that the demon Screwtape writes to his nephew are sent from Hell, where there is continuous noise. He tells Wormwood that in Heaven there is just silence and music. This is meant to be a terror to his nephew, as the demons ‘’want’’ (although not necessarily like) the cacophony.