My all-time favourite Hollywood sound effect is the so-called Howie Scream, also referred to as the "Yoouraaaaagh" scream, owing to the bizarrely high-pitched, distended scream let out by the "artist". The sound is a more extreme version of the Wilhelm Scream, usually used when someone is falling a considerable distance, due to the drawn out nature of the scream. It has been used in Broken Arrow, Face/Off, Last Action Hero, The Basketball Diaries, and Serial Mom, among countless other movies.
It's one overused effect that I nevertheless wish would be used a little more in place of the Wilhelm Scream, as the Howie hasn't quite yet penetrated the cultural consciousness in the same way, and still amuses when it appears.
Frequently sleep-deprived film addict and video game obsessive who spends more time than is healthy in darkened London screening rooms. Follow his twitter on @ShaunMunroFilm or e-mail him at shaneo632 [at] gmail.com.