Aaron Axelsen

Overrides the <code>wp_notify_moderator</code> function located in pluggable.php. By default, wordpress does not notify a comment author of a moderation 
event. This plugin will look at all users in the blog, and notify anyone who can moderate the plugin, along with the admins and the author 
of that post. This has been tested and does work with WPMU as well.

Post Author Comment Notification

Overrides the wp_notify_moderator function located in pluggable.php.  By default, wordpress does not notify a comment author of a moderation

Rolf Allard van Hagen

Normally, when a comment gets submitted to a particular post, the author of that post gets a notification about it. And when a comment is held for moderation (which depends on your sites comment settings) then the moderation notification is sent to both the post Author (if he/she has moderation rights) and the site’s Administration E-mail Address as configured under Settings > General at the same time.
On colaboration sites or sites managed by a webmaster or designer where the client is the post author, the site admin, with enough on his/her mind already, is bothered with each and every new comment in the moderation queue.
This plugin can change that.
Just install and activate it: All post comment moderation notifications will be sent only to each respective Post Author. If, by any chance, the post author has no moderation rights (Contributor level) or there is no valid author e-mail set then the default site e-mail address will still get the notification.
WordPress Multisite compatible, per-site or network activated or as a must-use plugin.
Plugin Settings
Options will be added in the future but for now, you can only change the plugin behavior via constants in your wp-config.php file.
Add them on a new line in your wp-config.php file, just above the line that sais: <code>/* That's all, stop editing! Happy publishing. */</code>.
These constants are currently available:
<ol>
<li>COMMENT_NOTIFICATION_RECIPIENTS – Controls the New Comment recipients. Default: “wp_default” corresponds with “post_author_only” WordPress default.</li>
<li>COMMENT_MODERATION_RECIPIENTS – Controls the Comment is waiting for Moderation message recipients. Default: “post_author_only”.</li>
</ol>
These options are currently available:
<ol>
<li>wp_default – The WordPress default behavior. Plugin does nothing.</li>
<li>post_author_only – Send notifications only to the Post Author e-mail address.</li>
<li>site_admin_only – Send notifications only to the Administration Email Address as configured on Settings > General.</li>
</ol>
Examples:
Use <code>define( 'COMMENT_NOTIFICATION_RECIPIENTS', 'site_admin_only' );</code> to make new comment notifications go to the site admin e-mail address, and no longer the post author.
Use <code>define( 'COMMENT_MODERATION_RECIPIENTS', 'post_author_only' );</code> to make comment moderation notifications only go to the authors e-mail address, and no longer the site administrator address (unless the post author does not have moderation rights).

Comment Moderation/Notification Recipients

Works great

Still works !

Control who will receive new comment and moderation notifications. Light weight, simple, safe and effective.

Post Author Comment Notification vs Comment Moderation/Notification Recipients