(in D&D at least)
Personally, I find "5% of the time the outcome is astoundingly good, and 5% of the time it's shockingly bad" kind of unsatisfying. Jarring, even. Picture playing darts and every 20 throws, missed the dart board completely, no matter how good you are at darts.
I haven't played pf2e but I think degree of success is a much more reasonable system.
I also prefer games that aren't flat probability. When you only roll one die, every outcome (on the die) is equally likely.
But I think a lot of people playing DND don't really care about rules, consistency, verisimilitude, or much anything beyond "lololol and then Kevin crit his stealth check so we said the goblin king didn't see him at all as he stole the throne the goblin was sitting on!!!". Which is fine, I guess.