I used ringdroid to make an alarm out of the first 10 seconds (instrumental opening) of "A Thousand Miles" by Vanessa Carlton, which the alarm app loops just like a system alarm.
The Last of the Mohicans Theme by Scythian would be a cool alarm.
Or the Top Gun Anthem by Harold Faltermayer and Steve Stevens.