I think it's probably ergonomically the best thing to learn for a drumset player. It's a shame I've only begun to practice it in middle age, and it feels good when that awkward secondary hand starts to develop. I've always admired the folks that do it- Blackwell (Chris and John), Sabal-Lecco, White, Phillips, Cobham, Husband, that smiling bearded left-handed guy on YT....um...who else?
I love working on it. It has opened up my playing quite a bit because I am able to maintain a hi hat groove while incorporating toms and other interesting elements without turning into a pretzel. Either hand can trade off holding down the backbeat depending on what's going on. For me, it is not at all about showmanship but keeping full sounding drumming and not thinning out a groove just to hit an accent. Why not keep some of that hi hat groove going throughout those drum fills? I promise you people will notice, and not because it's a "circus trick".