The example I gave in the issue summary is not valid because, apparently, we ...

The example I gave in the issue summary is not valid because, apparently, we can't use moderation state as a contextual filter in views. The patch could still be useful for other use-cases though. And when the day comes that there is a contextual filter for moderation state, then the example will be valid as well. :)