This is one of the more common superpowers that turns up in Rise of the Galeforces, and one of the rare few to be used by more than two Supers. Apparently, the Sonic Scream, as it's officially called, used to be quite popular.
The story A New Order has Usagi use this in her first youma fight, and then keep using it in almost all of her subsequent fights. It isn't at all lethal, but it can make most villains curl up in a ball of pain.
This Bites!: With his Noise-Noise Fruit powers, the Baby Transponder Snail Soundbite can emit a burst of sonic vibrations, tuned to a specific frequency, that is capable of shattering bone, stone and steel.
John in With Strings Attached can make a creepy, inhuman, bird-like screech, though he doesn't use it much, and it doesn't have any damaging effect—or, at least, he's never bothered to find out if anything can be done with it.
However, in The Keys Stand Alone: The Soft World, he uses it to extremely good effect when escaping from the psionics in the Guardians.
The titular villain of Ultrasonic has a particularly destructive version of this power, thanks to an akuma-possessed microphone.