Parodied in Clannad where in episode 19, Sunohara plays around with a keyboard that has a sound-effect called 'Hair-raising.'
"What was that, Nagisa-chan? Instead of Okazaki..." DUDUDAAAAAA! "YOU LIKE ME MORE?!"
There is one the movie adapation of AIR , right before Misuzu dies in the arms of her adoptive mother. It is generally considered very ill-placed, since instead of heightening the drama it diminishes it by cutting off the very sad music leading up to the moment. It is luckily not used in either the game or the television series.
Before his Seven Soldiers reboot, Klarion the Witch-Boy demanded that people refer to him as "Klarion... bum bum BUM... the Witch-Boy". He even refused to help characters who did not insert the dramatic sting. (You should not be surprised that Peter David came up with this.)
In another scene in the same movie, Dr. Frankenstein stumbles upon the Awful Truth ("You don't mean?" "Yes!" "It couldn't be!" "Yes!"). Every time Frau Blucher (*WHINNY*) says "Yes!", she plays a dramatic chord on a violin she's holding.
In Soul Music, the raven tries to verbally invoke this trope before revealing to Susan that her grandfather is (Dah-dah-dah-DAH!) Death. He never succeeds, as the Death of Rats keeps interrupting him, and calls him on it after Susan's gotten fed up and walked away.
Old-school Doctor Who, which made heavy use of multiple-episode storylines and episodes ending in cliffhangers, went through a period where every single episode ended with the same musical sting, which was written into the beginning of the music that ran over the closing credits. The 2005 series resurrected the sting, using it at the end of The Teaser and just before the closing credits.
Don't forget the swooshing sound at the beginning of the Theme Tune.
Similar to the Doctor Who example above, both EastEnders and The Bill have had very distinctive "drumbeat" stings, which would punctuate the final scene of an episode at the point of a cliffhanger, and lead into the credits.
The Saturday Night Armistice: The EastEnders sting was parodied in a segment suggesting that there was a drummer constantly following the characters around waiting for an appropriately dramatic moment.
The original series of Star Trek had stings worked into various motifs, which, like all of the music, were endlessly reused in different episodes. The king of these is probably the dramatic sting that ends the third season of Star Trek: The Next Generation. It's at the very end of this clip.
Roseanne: Lampshaded and parodied: the family has to deal with taxes, and every time someone says the word "audit" — Dun dun daaaah! The characters then look around to see where the sound came from.
The Muppet Show: Lampshaded when Gonzo asks for a "dramatic sting" when he announces an outbreak of "cluckitis"... and gets it. Later, when Scooter mentions the disease, the sting happens again... and he and Kermit react to it.
In an episode of Scrubs, a loud noise during a showdown between Cox and Kelso turns out to be JD trying to break a coffee pot (stuck on his hand) against a metal pole.
In The Whitest Kids U Know sketch "Opus", the character Rex Bosworth sings "BUM BUM BAAAAH!!" after he reveals what Freddy must do to free himself from Mt. Everest.
Every episode of LOST will end with either this or a montage set to Source Music.
The IT Crowd: Moss sets his phone's ringtone to the traditional "DUM-DUM-DUMMM!" sting. Naturally,it keeps going off at very appropriate (or perhaps inappropriate) times.
"Mum, stop calling me at work!"
60 Minutes arguably has a sting of its own: the distinctive ticking of the Aristo stopwatch that appears to end every news story.
Police Squad!: Parodied. Detective Drebin says his scene-ending line, and the sting plays as he looks at the camera. Then he looks away, and a second, lower-pitched sting plays. Then he looks back, and a third sting plays, and the scene finally ends.
Saved by the Bell uses the same generic sting, regardless of the situation precceeding it.
Damages Season 3 goes crazy with this, episodes one, two, and twelve (the second to last episode) especially.
In the original TV special/Movie for Jim Henson's Dog City, the characters find a note that reveals the identity of Ace's real father. The note ends, "Dun dun dah." The characters reading the note are initially confused before realizing that it's a music cue.
Prison Break pulls a very distinctive version of this at every single commercial break. This made sense in the first and possibly second seasons, when something dramatic would usually happen right before the ads. It became slightly jarring in later seasons when the audience is used to it, and nothing particularly important would happen before the cut.
WWE's Elimination Chamber gimmick match accompanies each new entrant being released into the cage with a big, dramatic music sting and flashing spotlights going across all the cages.
Extremely common in old-time radio shows, particularly of the mystery, horror and drama/suspense varieties.
Played with in The Phantom Hourglass: once when Link opens an empty treasure chest (the sting gets cut off), once when Link has just been vigorously shaken about by Linebeck (the sting is distorted) and once when Link receives a harmful item (the sting takes a grim tone).
The Song of Soaring has this kind of feel to it, especially because it fades out after you explode into a bunch of feathers. Oh no! Will Link arrive safely at his destination? Stay tuned to find out!
Evil Genius uses Stings to warn you anything that needs your immediate attention, such as an enemy agent breaking into your base or a super agent arriving into your base.
The first, PSX Digimon game played a happy little sting whenever you convinced a new Digimon to come join the town. Subverted when the chime starts playing, but veers off into minor key like a breaking-down music box when Ogremon abruptly makes a Villain Exit Stage Left instead.
Used often in Dead Space, including for when something falls off a shelf.
The "Dun! Dun! Dun!" happens in Super Meat Boy when a chapter is entered. It also happens at the end of the good ending.
Last Alert: "We are from the Force Project. You'll have to come with me". Dun Dun!
Potter Puppet Pals: At the end of "Ron's Disease", after Hagrid smacks Dumbledore with a cudgel with a resounding clang and otherwise no apparent effect on Dumbledore, Harry exclaims (to a sting), "OHMYGOD, he's an android!" Hagrid looks around in confusion, saying, "Wha-?" (to another sting). Dumbledore finally replies, "Yes, it's true, I am an android - a gay android." What follows is a rather original Lampshade Hanging of your typical Dun Dun DAAAH! sting, with the DAAH! lasting about five or six seconds.
Atop The Fourth Wall: Parodied in the review of 22 Brides. As the comic pulls the "We have you surrounded!" twist no less than three times in succession, the soundtrack plays a dramatic sting that gets higher pitched with each Reveal.
Parodied in Freakazoid!! numerous times. The most well-known example is in "The Chip", where it cuts from Dexter receives the defective chip to guest narrator Jack Valenti saying "Bum-bum-buumm!".
Animated sitcoms like Family Guy, The Simpsons and South Park love parodying this trope; the normal absence of musical chords will be made up for by the characters themselves providing the sound effects.
In the Simpson's episode Rosebud, the Simpsons come into possession of Mr. Burns long lost bear Bo Bo. When they first get it, the camera ominously closes in on a tag with the Scare Chord that says - "100% cotton". The chord cuts off and the camera frantically searches the bear until it find a tag saying "Property Of Montgomery Burns". Cue Sting.
And again in the episode with Mel Gibson, Beyond Blunderdome, where Homer suggests a movie idea with a dog with shifty eyes being the villain. The end of the episode ends with a shifty eyed dog. Cue Sting.
In Two Bad Neighbors, the scare chord is played when Bart skateboards by the Bush's home. Later, Marge tells Homer as long as he keeps the car filled with gas she'll be happy. Homer sighs in relief, then looks shiftily about as the camera zooms in on the car. Cue Sting.
One episode of Muppet Babies had Gonzo as "The Weirdo", a spoof of radio drama The Shadow. Whenever his name was mentioned, Rowlf played a dramatic sting on the piano... much to Gonzo's annoyance.
On an episode of Beavis and Butt-Head Beavis tells Butt-Head that he had a nightmare "where everything sucked." Butt-Head replies "But, Beavis, everything does suck!" Dramatic sting and Beavis screams. For a while, the sting was played anytime one said "sucks".
Phineas And Ferb has a sting for pretty much everything that happens Once an Episode: when Phineas announces he knows what they're going to do today, "Doofenshmirtz Evil Incorporated!"...They even have one for "fabulous", first used in "Dude We're Getting the Band Back Together" for Love Handel bassist Bobbi Fabulous.
An episode of U.S. Acres had a sting coming up every time "The Network" was mentioned]] (once it was even spoken by a character!). The executive that came up to watch the show's production, Aloysius Pig, even had in his card:
"What is this, opposite day or dramatic music sting day!?"
Archer, episode "Skorpio" has at least three such exchanges:
Malory: So you want this assignment? Archer: Yes. Malory: You really, really, want it? Archer: Yes, I really, really, want it! Malory: Well, too bad. Because guess what? Lana: Wah wah!
In American Dad episode "Not Particularly Desperate Housewife", Francine looks to expand her social circle and ends up with a group of women who discuss their affairs. Whenever the Asian member says something witty or catty, we hear a snippet of Oriental music. At one point she does her thing, then Francine tries to say something, only to get interrupted as the woman holds her pose and the music keeps playing. Later on, the sting plays when she says nothing; everyone looks at her, and she remarks "I farted."
Another American Dad example: Stan demands someone play a dramatic sting; the resulting music isn't dramatic enough and Stan is thoroughly disappointed.
Older Macintosh computers sometimes play a Sting (the "Chimes of Death") when they fail a crucial hardware check on boot, with the notes of the ditty telling a savvy tech what's wrong even when video doesn't work
Older Macs had fun vocals as well,for normal shutdowns. Arnold Schwarzenegger saying "I'll be back",anyone?
PCs are more boring, and use POST beep codes. In this case, if you hear anything other than a single beep, something very bad has happened.
Anyone who actually hasn't turned off Windows sounds will hear sounds for all kinds of things, including the rather jarring sound made when the computer can't complete something.