well here are a few notify ones i use. i have a bunch more but these are the ones i use mainly.
1) Victory Fanfare from Final Fantasy VII/Crisis Core/Advent Children
2) Star trek computer message "Priority one message coming on on secure channel"
3) Captain Kirk "Stand by to receive our transmission
4) Uhura message "Message from starfleet Captain" - from transformers actually lol.
Thread Necromancy FTW.
Anyway, I've been scouring the internet for the 'Message from starfleet, captain!' 'ringtone or sound clip' and finally found it here. I thought. However when downloading it, it doesn't seem to be valid? Corrupt? I dunno, anyone else have a working version?