Tried this on a staging copy first and it behaved exactly as described. Confident enough to roll it to production now.

We ran into the same situation last quarter. What worked for us was starting small and only adding complexity when a real need showed up.