With SharePoint 2007 you can now change the look and feel of Alert Notification emails for each list/web or custom type using AlertTemplates.xml. Provide corporate branding on the Alert Emails, or create your own triggers for the Alert using CAML.
View the Alert Notifications white paper on our download site to find out how: http://www.combined-knowledge.com/Downloads%202007.htm
Happy New Year!
Brett