Halorn had Chat Alert - http://www.halorn.com/aoprograms.html
I used to live by this, but with the advent of the new icons showing the cool down of a nano/action, I stopped using it. You can create your own text strings and assign your own sound prompt to it.
Hope it’s still an active d/l link and works for your purposes. 