I've tested the
Notify module for use with comment moderation queues, but unfortunately it does not send emails for such comments. You get only notification on comments that are added without a moderator's approval. You don't get notification for comments that go into the moderation queue and you don't get notification either when they are approved.
Recent comments
1 day 14 hours ago
1 day 14 hours ago
3 days 19 hours ago
1 week 1 day ago
1 week 1 day ago
1 week 2 days ago
1 week 2 days ago
1 week 2 days ago
1 week 4 days ago
1 week 6 days ago