I think the wonkiest dice I’ve ever played with for this would be Eclipse Phase. It’s a “d100 under skill” system, but uses the number you rolled as degree of success. So it’s like blackjack; rolling high is better, as long as you don’t bust. That difficulty modifier can turn a roll from amazing to awful. It’s not bad, and it’s never caused confusion, it’s just funny.
I think that’s kind of how contested rolls work in delta green. Whoever has the better stage of success wins (better stages are lower numbers), but if you both have the same stage of success, the one who has the higher number wins. It gives the edge to those with larger numbers in a skill, since they have more numbers that are higher than what the other person could get and still remain in that tier of success.