It doesn't provide nothing but grief, in my opinion. It is natural to fail sometimes even in things you are good at. It makes a story believable and interactions deeper.
I don't find it natural to fail at things you're good at. When's the last time you failed to tie your shoes? If that's too simple an example, consider this: if you know the trick to making mayonnaise, you will never
ever fail.
Also, (still purely subjectively) I find it hurts believability when my charismatic paladin fails to persuade someone with a sound argument that can only fail on a 1. What's the story justification for it not working? Did the paladin accidentaly flip the bird?
(All of this has been mentioned in the thread. I'm just trying to provide Larian with a data point).
As for the combat, the only remark I'd make is that critical misses matter. Because 95% to hit is not 100%. This auto-miss detached from your stats also makes fights unpredictable in a healthy way.
I agree with all of that, with the caveat that exactly 95% to hit is vanishingly rare in my experience. Rolling a 1 doesn't really need to have a special rule to trip players up. Still, I'm pro-crit-miss for the reasons you mentioned.
