Color me boring...
Ringtone: Ringer_RoomService (the least obnoxious stock ringer)
SMS/MMS: Notifier_Ready (the least obnoxious alert)
GoogleTalk message: The Harp Gliss sound effect from the
Simply The Best site.
Every other sound turned off.
I don't want my phone's notifiers to draw the attention of anyone but me.