Just noticed this today while working in CS2007 Forums. George J. Capnias wrote a great notification module with CS 2.1 to do this but is another case where good CSModules and Add-Ons find their way into Community Server Core. I tested the moderation notification, by the way, and it works great.
