What sort of story would you consider a success story? It sounds like private accounting management (aka Controller) doesn't sound like success to you, and public accounting management (Audit or Tax manager) doesn't sound like success to you, so not sure what form of success you're asking about from the CPA. š
Myself, I became a Controller at a young age (23 when I interviewed, 24 when I started work), and I believe the opportunity wouldn't have presented itself if I wasn't a CPA. Granted, it's still not a “typical” story and YMMV and all, but I think the CPA was a necessary ingredient, and would consider myself a success story. Also, it is a small company – college with around 1,000 students – but despite all the “Granted…” qualifiers, it's still pretty darn good for a 24-year-old (though now a couple years older š ).
More generally, a lot of the jobs beyond the Senior Accountant level require the CPA designation, and even some Staff/Senior at least state it as a preference. If you want to be a CFO, it'll probably be easier with CPA than without. But, doesn't mean it's absolutely necessary; my predecessor in my Controller job wasn't a CPA, and neither is my CFO boss. But, I'm pretty sure that had I applied with just a Bachelor's, they wouldn't have given me a second look; CPA shows I've put in some extra effort.