Catalina's Sonic Blast on Space Cases, which apparently all people from Saturn have.
Lorne of Angel can hold a song note at any pitch, pretty much forever. His screams brought several demons to their knees holding their ears in pain, and, judging from the background noise, it can shatter glass as well. The real irony is that where he comes from, singing in general is considered a sonic weapon because they have no concept of music; he's viewed as something akin to a Person of Mass Destruction with none of a nuclear warhead's huggableness. In a multi-episode arc where the group goes to his home dimension, he holds off a lynch mob by bursting into a Mo-town number (until someone rides by on a horse and just knocks him out).
Echo DeMille in the Heroes webisodes and Jesse in the show proper. And Sylar too once he kills Jesse and takes his power. And just like every other power besides telekinesis that he just had to have, he never actually uses it.
Myth Confirmed: A trained human voice singing a sustained high note can shatter a glass. This only works because of resonant frequencies. A glass has a very simple shape, so it will have a resonant frequency that you can use to build up vibration in the glass until it shatters. Objects (like buildings) with complicated geometry and a variety of materials won't normally have a single resonant frequency that knocks them down, and at least some of the materials will tend to damp out vibrations. Resonance doesn't perform amplification of energy, only storage. For mechanical energy to build up in the structure, it has to be added faster than damping turns it to heat.
The exceptions to this rule are usually spectacular and expensive. After the horrible counterexample of the Tacoma Narrows Bridge (the bridge pictured in the linked footage), engineers try not to build structures with a resonant frequency any more.
In the CBBC series Freephonix one of the three 'Freewavers' and Protectors of the 'Thirteenth Note' can use her singing voice as a weapon.
In The Librarian Simone Renoir shatters all the windows of a defunct abbey-turned-nightclub with a single high C. Of course she is a vampiric opera singer who's had centuries keep her voice well trained. More importantly, she was standing in the one spot in the abbey that would amplify her voice to levels loud enough to shatter all the windows.
Da Chief from Get Smart can do this, which comes in handy when a villain with eyeglasses is holding him and Max at gunpoint ...
Queen Mab from the 1998 miniseries Merlin. Apparently, she was the inspiration for the myth of the banshee.
In "The Ice Warriors", Victoria screams to cause an avalanche that kills the Ice Warrior coming after her.
In the story "Fury of the Deep", Victoria's screaming defeated the seaweed creature.
The (Fourth) Doctor shatters a window by bellowing at it in "The Power of Kroll".
Teen Wolf has Lydia, who turns out to be a banshee. Her scream won't do sustained damage, but it will daze people and shatter glass.
In season 5B, we learn that it can do far more than that. A few voice training sessions with fellow banshee Meredith reveal that her scream can grievously injure and even kill people at maximum power. Gabriel Valack learns this the hard way after forcibly amplifying Lydia's abilities. In the finale, Lydia's supernatural voice allows her to banish the spirit of the Beast of Gevaudan by shouting the name of its host.
Supergirl: As of "Manhunter" Siobhan Smythe aka Silver Banshee has revealed this as her power, in line with her appearances in the comics.
A one-shot villain in Alphas was introduced as having sonar powers. It turned out that his abilities were much more dangerous, allowing him to weaken buildings with gradual vibrations, and finally flat-out blast people.
Joan Collins played The Siren in the last season of Batman. And what an ear-piercing sound it was.
Arrowverse has three characters with the ability: Dinah Drake (new Black Canary), Laurel Lance (from Earth 2, Black Siren), and Siobhan Smythe (from Earth 38, Silver Banshee). Also, Black Canary's sonic-emitting device (modified by Cisco) is meant to disorient rather than hurt. One scene even has Dinah and Black Siren try to blast one another at close range. Naturally, both are flung back by the force of their screams interacting.