I've been tinkering with the notifications system tonight. I hope I didn't flood anyone's inbox.

I had subscriptions.modulenotifications.module was better. It's a more general framework forked out of the former. Example of generality: it can push to your iPhone.

Does anyone have input on the notifications system? The links above should help you see what's possible with Drupal. This comparison of modules should also help.