Here's a couple I sometimes use for message alerts:
From Casino Royale, Versper's message alert:
Vesper.
From The Scent of a Woman, Al Pacino saying
"Hoo-ah!".
From 2001: A Space Odyssey, the computer HAL saying,
"There is a message for you."
And the timeless classic, Homer Simpson saying
"D'oh!"