I respectfully disagree on one detail. In my setup the opposite held true, though I suspect it comes down to community size.

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

This is the answer I wish I had found six months ago. Would have saved me a weekend of trial and error.

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.

Following this thread closely. We are about to face the exact same decision and the replies here are gold.

For what it is worth, the same approach works with the PMPro adapter — the membership side is identical from here.