I am currently using Triggers + Actions to send the node author an email when a new comment is added.
Some of the commentators on my site do not require approval (registered users and repeat commentators).
I would like to indicate in the mail whether the comment requires approval - or send a different message all together in this case. I didn't find any way to configure this.
Answers to a related question suggested the Rules module, but I didn't find a way to make a condition based on whether the comment needs approval.
Edit: I think that the relevant conditions is about comment:status. This field doesn't appear as a data selector in Rules, for some reason.