I've always had beef with crit failures where it not only isn't balanced the way crit successes are. In other words, they don't really have a place outside of combat, and even there they should be not only rare, but realistic.

The worst a crit fail should be is giving the enemy an attack of opportunity. That's it. Maybe you could stretch it into something like dropping the weapon, or hitting an unintended target that was realistically in line with the weapon's movement, which still doesn't mean it would do full damage.

I dunno how many of the DMs that use it have actually been in a real, life or death fight, but it can't be a lot. I would say it's near zero just because of the stories people tell about crit fails in combat.

Strangely, where it would apply more is in skill checks that wouldn't normally be bothered with. But that would still be situational, like a carpenter hitting their thumb with the hammer. It wouldn't typically end up with some kind of devastating effects 5% of the time, either. Even when it did end up catastrophic, the fail on that kind of skill still wouldn't mean total failure often enough to merit it being a meme level thing. Even a drunk carpenter that hammers his thumb and needs to see a doctor can come back and finish the rest of the job. It might not sell, but the table would still be a table, if you see what I mean.

A nat 1 as a meme is awesome, I love the humor of it and play with it myself. But in game it not only isn't RAW, it isn't balanced out the way it sometimes gets implemented.