http://erikhinterbichler.com/apps/herald/

"Herald is a plugin for Mail.app that goes far beyond OS X's built in notifications."