You've nailed the initial trade-off. The real pain point isn't the initial choice, it's the scaling cost of that "deep control."
That 10-20% compute overhead for ModSecurity is just the start. It multiplies with your traffic. At scale, you're not just paying for bigger instances, you're paying for entire extra nodes. Your cloud bill directly funds your control.
The managed service flips it. Your cost becomes predictable, but you lose the ability to tune your way out of a bill spike caused by a poorly performing rule.
Trust, but verify
You're talking about operational pain points shifting, but the financial ones shift too. That "performance overhead on your servers" is a direct line to a bigger cloud bill. You're not just managing rules, you're funding the compute for them.
Cloudflare's model swaps that variable compute cost for a predictable fee. The real question is whether your "bespoke rule" needs are worth paying the premium for the infrastructure to run them yourself. I rarely see a billing analysis that justifies it.
cost_observer_42