Hi,
After a lot of trial and error I had to scrap the use of the Revisioning module as it simply made things for the authors/moderators to complex to usable, but also created a lot of not so nice side effects for other content as mentioned here. Plus when cleaning up after it I got a total WSOD and 404 on every page, took me hours to get the site back...
Now I have a workflow that has three stages In Draft, In Review and Live based on this tutorial with some modifications to make it work nicely without the Revisioning module.
The downside though is that when an author wants to update a node it will be unpublished until it is In Review and OK'd again.
It is still my goal to have the latest reviewed version live during update, but it will have to wait until there either is something more usable or I have the time to learn to develop it myself...
I have tried to automate as much as possible using actions and triggers, such as when a moderator puts it live it is automatically ticked as published and when it is moved from live to In Draft or In Review it is automatically unpublished.
Trigger to create new revision
What I haven't been able to figure out is how to create an action that automatically creates a new revision when it is moved from Live to any of the other two. I would prefer to let the workflow/triggers manage this as it would make so much more sense to have the create revision option ticked of for the content type.
Avoid workflow tab/form fieldgroup for authors
Another thing that would be real sweet is if I could skip the workflow tab and the form fieldgroup for authors and only have the workflow comment field for them.
What I am thinking is basically that when they are working with their content they have two buttons, Save Draft and Save for Review. Save Draft will simply keep it in the In Draft stage and Save for Review will move it to that stage without they having to go to the workflow tab.
Same with when they need to update it, they have an Update button that automatically will move it from Live to In Draft again.
I think something like this would make content editing much simper for authors and it would involve much less education to get "pencil heads" to understand technical stuff... They will simply be able to work with their content without having to try and understand why they have to put content in various stages or what versions are.