I use one that I've been using for years that's meant to be entirely subtle, but gradually increases its efforts to get your attention over time. It began life as a MIDI ringtone, but I like it so much I had to convert it to MP3 for the N900..

MP3 Here

I've got the original MIDI file somewhere if anyone wants to experiment with different instruments/effects..