RPGMemes

Yes. Pathfinder 2e has a good one.

Rolling a nat 1 or 20 doesn't mean Critical success/failure. It means it moves the success status up or down one: Critical success, success, failure, critical failure. In addition, that game also specifies that a critical is also achieved by your result being +/- 10 of the result.

So if you're attempting a DC 35 check (arguing with a god, let's say) with a +2 mod, a nat 20 would get you a result of 22, a critical failure. But a nat 20 bumps it up one success, so you get a regular failure. Whereas if the DC was 25, a 22 is still a failure but your crit means it's a regular success.

This has middling applications in D&D 5e, though. PF2e's DCs and skill bonuses are not constrained by 5e's Bounded Accuracy. So they can vary a lot more. In D&D's case I had to pull pretty much the highest possible DC the game suggests so there's not a lot of use cases for this. But it's still a better system for including criticals on skill checks. And this is why 5e doesn't have them normally.

For most skills, there low level human equivalents in the real world who will never "choke under pressure" once when doing the thing thousands of times throughout their life. When we're talking about one of the heroes of a tale that are also "the best of the best", I think it's ok from a literature, fantasy, or gameplay standpoint for them to have a 100% success rate despite the fact that a failure risk would be possible in the real world. This is doubly true (DM point of view) when failure would be uninteresting or mess with suspension of disbelief. If an ace pilot is trying to fly through a bad storm to land where the firefight is going to happen, he bloody well makes it. I'm ok with "success with complications" on a 1, but the complications should be fun as well. You land ok, but the wind that hit at the last minute caused some damage to a wing. You might need to find another way out" or even "unfortunately, you weren't able to fly evasively enough because of the buffetting winds, so they know you're here.

Nobody wants Skyrim syndrome, where a master thief gets caught pickpocketing someone (we Bethesda players do something called save-scumming to keep the immersion). I used to go to a pickpocket show at the local renfair and the performer never got caught. And he was not a "master thief".