I'm actually finding mine to be a little bit dull to be honest. Rolling on the wild surge table has been pretty rare despite the various DM's I've had who have been generous with Tides of Chaos, simply because I so rarely need to cast more than a cantrip in a combat. And even when I do, DM's can't use Tides of Chaos every turn otherwise I'd be getting advantage on just about every roll, and the 1 in 20 chance has never come up once.
The only time it really made an impact was when I rolled a 01 after using Tides of Chaos and casting a 1st-level spell. The subsequent rerolls summoned two unicorns and sent me to the astral plane. Other than that, some pretty music and a huge amount of healing that I didn't need.