I had a Blackberry before I got my droid. One of the great features of the BlackBerry was that I could set different notification settings for different situations. For example, in addition to the usual silent, airplane mode, normal, etc, I also had a custom one called Pager where the only notification sounds that were played were when I received a text message from the paging system at my workplace. Everything else was silent.
I work night shift, and not having to wake up for every email, text message, or phone call would help me sleep a lot better! I can't find anywhere to customize this on my Droid (D1), though. Thoughts/suggestions? Do any of the newer Droids (I was looking at a droid pro) have this functionality?