Trigger action on node revision? WILLING TO FUND

We have Workflow, Actions, Views, Revision Moderation and other assorted modules enabled on a linux system. As far as I can tell, everything is working as it should. However, there is something I'm trying to figure out how to do and I don't know if I can do it with Workflow + Actions or Workflow-NG or if I won't be able to do it at all.

Like many people, we need to have new content reviewed before publication by a small group of editors, though the number of users who can potentially submit content is larger. However, we also want to allow users to make changes to existing content, still subject to moderation, and we need to use revisions so we can roll back to an earlier revision if needed. We had been using Modr8 and Revision Moderation modules, but the editors want to be notified by email when content is submitted. This would seem to be a job for Workflows and Actions.

I set up a workflow with a simple set of three states: Draft, Review, and Public, and I created views to show editor queues. I can set actions to notify users via email and/or a screen notice when a node enters the "Review" state. This works fine for new content.

However, when a user edits an existing node, a new version of the node is created. If I enable revision moderation, this new version doesn't get displayed to unauthorized users (correct), but it also doesn't get flagged as needing to be reviewed, i.e. the state doesn't get automatically changed to "Review," and I can't find an action to do this. Therefore, the editor isn't notified that the node has been revised and needs to be reviewed. I don't want to take the whole node back to "Review" state, either, which is what would happen with the current Workflow Access settings, because ordinary users aren't allowed to save a node in "Public" state.

I get a filter for moderated items in Views, but it doesn't seem to get items which have revisions needing moderation -- I guess that's stored differently than in the usual moderation flag. (I also can't seem to find the version author in the view anywhere, though I suppose that's not something to be addressed here.) I'd really like to have all the items needing moderation in the same view, anyway. Ideally, I'd like to have the link to the node go to the most recent revision, as well, so the editor can just look over the node and click "publish revision" as needed.

Articles I have already looked at:

http://drupal.org/node/97802
This looks like what I need, but its status is "postponed."

http://drupal.org/node/144270
Publish pending revision action - Drupal 4.7, though.

http://drupal.org/node/122197
Similar needs, but no solutions

http://drupal.org/node/125243
Marked as a duplicate of http://drupal.org/node/97802, above

I tried using Workflow-NG instead, but I couldn't see any way to detect the revision state from there, either (and I couldn't figure out how to send email to an arbitrary editor, rather than the current user or the page author).

Any suggestions? We may be able to fund development if necessary.