I've collected these over the years. Nokia phones, SonyEricssons, you name it, I've used it. Here's a few that are short:
From Casino Royale, Vesper's text alert:
Vesper
The incomparable Homer Simpson:
D'oh!
Just a cool sound:
Sonar Ping
Al Pacino from Scent of a Woman:
Hoo-ah!