I felt exactly the same way the first time I read about them, but for boardgame design. But I found that in practice the probability of the effect just isn’t really enough to make it fun, at least in my attempts, and I ended up just using rock>paper>Scissor mechanics instead, because it’s both more noticeable, and has the benefit of being instantly recognized and understood intuitively by players.

I think it would be pretty intuitive if we had red, green and blue dies for attack >> feint >> parry.

And in rpg d20, d12 and d10s are pretty common, so I think it could be tweaked for larger effect.

The challenge would be to make attributes matter in a non-binary and fair way (in the obvious d6+attribute vs d6+attribute system attributes only matter when they overcome the threshold).

I have used genetic algorithms to search for non-transitive die triplets among the standard set of platonic dice, and exhaustively searched d6 and d8 numberings. If one insists that the advantage of A over B be the same as the advantage of B over C and C over A, then 61% is the best (farthest from 50%) that can be achieved for d6 and d8, and the best that I have been able to achieve for any larger dice.