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.

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