I was in the mood to see someone scream but good, really let it out. The first thing that came to mind was the Beastie Boys doing "Sabotage" on Letterman. Man, there's one scream by Ad-Rock near the beginning that's just awesome, really sets the tone, but the one near the end is all-time. I'm not going to tell you exactly where because I think you need to invest yourself in the song to get the full effect.
~ NOTE: ALL MEDIA IS HOSTED BY THE BLOGS & SITES NAMED BELOW ~Listen:
Beastie Boys - Sabotage mp3 at Internet Archive
Beastie Boys - Sabotage at YouTube Official video, by Spike Jonze
Sabotage - Song entry at Wikipedia