Hi,
Fellow sufferer here. My experience is this:
1) complacency. The minute I think I can play something without giving 100% focus I mess up.
2) running before I can walk. I'm really quite a poor player, which is undoubtedly not helped be learning 4 & 5 star songs. I've done very few lessons and tend to go straight to learning songs, as that's just more fun for me. As a result I make a fair few mistakes.
3) fear. I can change chords reasonably well, but due to the shape of my fingers I have difficulty with a couple of what are probably easy chords for most. Em7 (0-2-2-0-3-3) is the one that springs to mind. I hate that chord and when I know it's coming up I get apprehensive and usually mess it up.
I've taken comfort from the fact that even really good, professional players make mistakes. There's even a blunder by one of the instructors on this site, which is nice :) I also watch a lot of Rick Beato on YouTube, and he was asking Misha Mansoor to show him a bit of one of his songs. He messed it up quite badly and told Rick that he'd need to put some practice in. These things show me that our instrument isn't easy and we shouldn't be harsh on ourselves, especially at the level we're playing at.