There's a minor villain in Justice League, Colonel Vox, who had this weird mechanical throat that does this. He's basically a pastiche of a Bond henchman, so it comes as no surprise that this ultimately gets him when it comes time for the karma to kick in.
The mechanical throat is what he talks through. His actual voice is what does the killing.
In the episode "Hidden Talents" Kim Possible is entered into a talent contest by her sidekick Ron, which she's not happy about because of her awful high notes. It turns out her singing can break six feet of ice, useful when the villains trap her under that, though never mentioned again.
In one episode, Eek The Cat tries to get the lemons while climbing on a lemon tree at Sharky's backyard, but fails and eventually falls into a thorn bush, which prompts him to scream so loud that the camera shakes and the lemons fall off of the tree and bury him.
Subverted in The Simpsons, when Lisa trains her voice for an "American Idol" competition. Just after she appears to break a glass by hitting a high note, the camera pans out and Homer says that he was shooting the glass with a BB gun every time she did so.
The EVO Circee in Generator Rex can shout with varying intensity at most any frequency. The can knock people back, create horrible noises, and hit resonance frequencies to shake things apart.
It was said that in an off-scene incident, she accidentally hit the natural resonance frequency of cotton and blew a bus driver's pants off.
The Garfield and Friends segment "Screaming with Binky" revolves around Binky The Clown disturbing someone who is doing an activity that requires concentration.
In the Adventure Time episode "Wizard Battle", Finn lets out a Big "NO!" so big it knocks out Abracadaniel, earning Finn victory in the eponymous Wizard Battle. It also earns him mockery for using a Power Shriek, "the most shameful form of magic."
In a Wing Dings blackout, Dick Dastardly invokes the line as he protests the squadron's lack of activity during some downtime. He shouts "IT'S SO QUIET YOU CAN HEAR A PIN DROP!!", followed by Muttley rolling a bowling ball at a pin which knocks Dastardly out cold. Zilly quips, "That's one pin he didn't hear!"
Dutch's car Whiptail in Motorcity is able to do this.
She Zow has his/her Sonic Scream power (the strongest out of all of powers), it can do anything from breaking every piece of glass within a five mile radius, to destroying really big boogers, to being a pinpoint concussive blast.
Young Samson & Goliath. When the dog Goliath is changed to his lion form, he can make a roar that selectively destroys objects in the nearby area.
Elsa the ghost angelfish from "Wake,Rattle, and Roll" can cause people to go flying and objects to break with her shouting.
Freddie from the American Dad! episode "A Ward Show" every time he's upset he lets out a high pitched shriek in which the frequency is strong it causes people's eyes to pop out.
One episode of Mighty Max featured an indestructible Norse god Max nicknamed "Lockjaw" due to his jaw literally being locked shut for good reason: he had this trope for an ability, and he's chasing them for the key to unlock his jaw. Unable to destroy him due to his immortality, Max eventually figured out a way to turn his power against him, and allowing him to uncork his full fury in a landslide zone, causing massive debris to bury and contain him.