In the ancient past, the dragons and their Dragon Cults took over much of Skyrim. Seeking a way to defeat the Dragons and their Cults, the ancient Proud Warrior RaceNords prayed to the Divines for aid. Their prayers were answered and they were taught how to use the language of the Dragons themselves, which they called the Thu'um (or the "Voice"). Led by the Tongues, masters of the Thu'um, the ancient Nord armies vanquished the dragons and their Cults, then forged an Empire that covered nearly all of north Tamriel. A succession crisis would eventually tear it apart, and then the use of the Thu'um as a weapon of war dropped dramatically after their defeat at the Battle of Red Mountain, following which one of those Tongues (Jurgen Windcaller) founded the "Way of the Voice" to use the Thu'um only honor the gods.
In modern times, the Greybeards continue to follow Windcaller's "Way of the Voice." They live in a monastery known as High Hrothgar near the top of the Throat of the World, the tallest mountain in Tamriel. So powerful is their Thu'um that they are usually sworn to silence in order to not destroy everything around them simply by talking. Even their faintest whispers are known to shake the mountain on which they live. They Greybeards accept anyone who wishes to learn the Thu'um and follow the Way of the Voice. It is explained that anyone can learn to use Thu'um, but it takes a great deal of training, mostly to learn the true meaning of the words in the shout. Anyone can try speaking it, but you need to put your soul into it for magic to happen.
Skyrim is the first game in the series in which the Thu'um is seen in action. The Player Character is a legendary Dragonborn (or Dovahkiin), a rare mortal blessed by Akatosh with the immortal Aedric soul of a dragon. Akatosh creates those who are Dragonborn to be the natural predators of the Dragons, being capable of ending their Resurrective Immortality by absorbing their souls and using those souls to increase their mastery of the Thu'um. After being revealed as a Dragonborn, he/she will be summoned by the Greybeards to High Hrothgar for training. When they call for the Dragonborn, all of Skyrim can hear it.
Others in Skyrim are revealed to be able to use the Thu'um as well. Ulfric Stormcloak, leader of the Stormcloak rebellion, studied with the Greybeards and used the Thu'um to win his duel with High King Torygg, kickstarting the Skyrim Civil War. Additionally, many of the DraugrElite Mooks (the ones with the words "death," "over," or "lord" somewhere in their names) were the leaders of the ancient Dragon Cults and can use the Thu'um as well. Miraak, the first Dragonborn and Big Bad of the Dragonborn DLC as well as the Bonus Boss Ebony Warrior can also use the Thu'um.
Online introduces Daedric Titans, dragons who have been corrupted by Molag Bal, the Daedric Prince of Domination and Corruption. While stated to be only a "crude imitation" of the "true" Thu'um, Titans possess the ability to speak a spell of flaming essence-drain that can debilitate an opponent with a single word.
Online gives this ability to Winged Twilights, a bat-like form of lesser Daedra with some harpy-like traits. They have the ability to stun opponents with their shrill, high-pitched shrieks.
The Mercenary (Melee Area of Effect) class in Dragon Nest has an entire range of shout skills. One of the higher level ones actually creates a vacuum when he inhales to bring enemies closer so that the actual shout can hit more of them.
Pokémon has a few attacks like this, such as Uproar, Echoed Voice, Noble Roar, Disarming Voice, Snarl, Sparkling Aria, and Hyper Voice. There's even one called Round which becomes stronger if both Pokémon in a team battle do it at the same time. There are also sound-based status-affecting moves such as Screech and Supersonic, and the Pokémon ability Soundproof can protect a Pokémon from any sound-based attacks. Howl can boost the user's own Attack Score, while Roar can scare a wild Pokémon away or force a trainer to switch Pokémon. The evolutionary line of Whismur/Loudred/Exploud and Noibat/Noivern are also all based on this trope, and both can use the most powerful shouting attack, Boomburst. Sound-based attacks can pierce Substitutes without any additional abilities required, and the Hidden Ability Liquid Voice makes all sound-based attacks Water-type.
Queen Sindel from Mortal Kombat. Notable in that she can scream the flesh off people.
Redeads in The Legend of Zelda can stun people with their screams, which get higher and more shrilled over the years.
Skull Kid in Majora's Mask, whose scream speeds up the falling of the moon.
Pol's Voices can be stunned by the player shouting into the microphone—on systems that have one, that is. Phantom Hourglass was the first game where this was possible outside Japan, but it could be done in the original The Legend of Zelda using the microphone built into the Famicom's second controller.
Warriors in World of Warcraft get a few "shout" attacks. They don't damage, but at least one causes "fear".
As of Mists of Pandaria, Warriors can pick a talent called "Dragon Roar", which on top of being a possible Shout-Out to Skyrim, deals fire damage to all nearby enemies.
Warlocks also have Howl of Terror (causes fear), priests have Psychic Scream, but the name implies it to be a magical effect rather than actual noise.
In Guild Wars Shout skills are simply skills that have no cast time (and, indeed, can be used while you're casting or using another skill) and have an effective range of "earshot" (which is approximately aggro range). Their effects are generally damage modification (either increasing or decreasing it), but one shout, "You Move Like A Dwarf", actually damages, knocks down, and cripples whichever foe you have targeted when you use it.
Similarly, The Lord of the Rings Online has many, many damaging shouts. Minstrels alone get at least three ways to kill via yelling, with bonus points to Dwarven minstrels, whose shouts, rather than wordless "AAGH!" of every other race, consist of the war-cry "Baruk Khazâd! Khazâd ai-mênu!"
The barbarian of Diablo II has a number of vocal capabilities (howl, taunt, shout, battle cry, battle orders, war cry and battle command) with a number of effects on enemies ranging from fear, stunning or status penalties all the way to immediate damage. And they can grant allies temporary buffs.
In Condemned 2: Bloodshot, there's a whole cult with this ability. You're one of them, and gain it for the last level.
Mega Man and Shade Man had the sonic weapon "Noise Crush" in 7, but that came from their Arm Cannon.
One variation of the Trumpy Virus produces a blast of music that, while it does not impair you in any way, will still prove an annoyance, by completely refilling a fellow mook's (or it's own) HP. As it is usually teamed up with viruses with sizable HP, as well has having a lot itself, you WILL want to defeat it first.
In a twist on this trope, the Street Jam psych from The World Ends with You is triggered when the player stimulates the DS' mic. It comprises of Neku summoning giant speakers that blast sound into every Noise in the current battle. A variant, the Twister psych, turns mic stimulation into gusts of wind that blow enemies up and then slam them down.
In Command & Conquer: Red Alert 3 the Allied attack dog and Soviet war bear have functionally-identical stun abilities based on their roar/bark. The dog has an amplifier to help, and can pass this along to the Multigunner IFV if the dog hops in the shotgun seat. The Allied dolphin (also in Red Alert 2) has an amplified sonic weapon as an actual damaging attack that can take out boats if they attack in groups.
In Tiberian Sun, the GDI had the Disruptor tank which was derived from Scrin technology. It fired high powered sound waves at targets, and was one of the more powerful units in the game. In Tiberium Wars, GDI used sonic weapons as static base defenses, and later built smaller mobile versions as well. According to the backstory, this technology was useful in combating the spread of tiberium, though it doesn't seem to have much of an in-game effect.
Universe at War has the Amplifier for the Novus faction, which basically functions as a sonic artillery unit.
Knights of the Old Republic II: The Sith Lords has the Force Scream power, which is one of the best Force powers in the entire game. note At master level it deals 7d6 points of damage AND reduces all attributes by 6 points (-3 modifier), thus reducing the enemy's Vitality, Force points, damage, defense, chance to hit, saves...pretty much everything. Not to mention it is tougher to save against (10+level+Wisdom mod+Charisma mod rather than 5) and deals area damage.
In the sequel, Star Wars: The Old Republic, Sith Warriors have both Force Scream, which deals damage, and Chilling Scream, which slows enemies.
The sirens in God of War II have a migraine inducing attack of this nature.
BioShock Infinite, meanwhile, has two monstrous enemies who have screaming as a big part of their motif. The Siren's voice is so powerful she can tear through the veil between worlds, allowing her to summon the souls of the dead — she uses this to resurrect the enemies you kill. The Boy of Silence, on the other hand, is a living alarm system whose freakish scream draws swarms of enemies to kill you.
In New Super Mario Bros. Wii, Bowser does this in the final battle, but it doesn't do any damage, just pushes you back a little.
Bowser Jr. uses sound waves as part of his super ability and mega strike in Mario Strikers Charged.
Rikuo/Aulbath from Darkstalkers has a special move called Sonic Wave, where he emits ultra-sonic waves to stun his opponents and that inflicts some damage on them.
City of Heroes offers Sonic Attack and Sonic Resonance as powersets. The default animation for these powers are a range of screams and shouts. Oddly, while Sonic Attack damages targets and renders them vulnerable to more damage, Sonic Resonance includes a number of powers that make your allies tougher instead. All by making strange shrieking noises.
One of the warrior's abilities in Dragon Age: Origins is "War Cry". When upgraded it can knock enemies off their feet.
Some minor enemies in Golden Sun games can use a vocal attack. Bats unleash sonic waves, Harpies let out a shriek, and Scuttlersbellow a bloodcurdling cry. These deal damage and sometimes prevent an action or even stun a character. Also, until Dark Dawn, unleashed weapon techniques were narrated as "(character)'s (weapon) lets out a howl! (technique name)!"
Video Game/Warframe has the Banshee warframe, which primarily relies on sonic strikes and echolocation to find and kill enemies.
In Brütal Legend, General Llyonwhite does this to a mirror falling on him. Unfortunately for him, his scream breaks the mirror and the huge, sharp shards kill him
In Monster Hunter, the majority of the monster's roars have the ability to stun you and, for the most part, can only be avoided by rolling or blocking with your weapon. However, some monsters (such as the Tigrex) have roars powerful enough to inflict minor damage and send you hurtling dozens of feet across the landscape.
In Archon, Banshees have this as their power. It has very short range, but they are the only melee unit that can move and attack at the same time.
In Dune II, after getting the IX building upgrade, House Atreides can manufacture Sonic Tanks, capable of hitting multiple targets if they're all in the line of fire.
In the flash-based webgame Swords and Sandals 2, a valid min-maxing strategy is to focus mostly on Charisma, so that your Taunt skill becomes your free, deadly, ranged, and only, weapon.
Dead Rising 2: Metal band Angel Lust obliterates an entire horde of zombies by blowing up their heads with a deafening Big Rock Ending. This specific trope would best apply to Jeanna, the band’s sultry siren of a lead singer, but her Metal Scream is only implied, and never actually heard on the soundtrack. Rescuing the band allows the player to craft a "Power Guitar", a combination of an electric guitar and amp that will blow the heads off of zombies with The Power of Rock.
Orc barbarians in Heroes of Might and Magic V are forbidden from learning magic, instead they get a selection of battlecries that function as buffs for their soldiers.
In the Spin-OffPersona 4: Arena, Kanji Tatsumi's standing heavy normal attack is him screaming "You want some?" with a large speech bubble appearing behind him and damaging the opponent if they touch it.
Kyouko Kasodani from Touhou is able to manipulate sound waves. Her attacks are normally centered on her amplifying her own voice to ungodly levels and stunning her prey with infinitely-repeating echoes. On a related note, the Prismriver sisters' attacks include actual visible sound waves in the form of musical notes, but their powers are limited to what their instruments can do.
In After The War, certain hybrids will attack you with a cone of loud sound, which will also knock down even enemies caught in the middle.
Atlantis No Nazo has a microphone powerup that lets the player stun all enemies on the screen by shouting into the second Famicom controller.
Lakelurks are based on the Mirelurk King from Fallout 3. He has the same attack, and it does hurt a lot (it ignores armor).
New Vegas also has the Sonic Emitter in the Old World Blues DLC, basically a gun which fires sonic blasts that play hell on anything mechanical, and can disable forcefields. You can also bring more samples to one of your AI helpers so he can tinker with your emitter and change the blast's effects. Or, in his words, "Get me a good sample base to work from and I can whip up a wave that makes Jericho look like a kazoo".
If you ever so sadly happen to pull a mandrake out of pot without the earplugs equipped in Mad Father, it unleashes a hellish scream that can kill Aya.
Angry Birds 2 gives Red the ability to give whatever's in front of him a shove with his battle cry, which can help topple structures.
The titular Charlie Murder and one of his fellow bandmates Kelly scream into a microphone to use magic attacks, which can be upgraded over time.
House of the Dead: OVERKILL has the Screamer boss who, well, screams at you to attack. Apparently, this has the side-effect of messing with G and Washington's minds as they begin to hallucinate during the battle.
The Archon from Nexus Clash can sing the Song of the Word, which draws upon the combined portfolios of all the gods of good to purge evildoers from an entire building or area. Depending on the beliefs and zeal of the particular Archon, "evildoers" may mean anything ranging from only actual demons and murderers to anyone less than perfectly holy.
Shizuka Kanina (Yes, Rosa Canina from Maria-sama ga Miteru) appears in the doujin Fighting GameMaribato! as a playable character. Shizuka is able to use her singing voice as a weapon. When she sings, she produces notes that cause damage; Can also create a force field to protect her, for her DP; She's also able to produce a soundwave that temporarily stuns her oponent, and leaving her wide open.