I agree with two-thirds this. Self-inserts aren't necessarily cringe in and of themselves, they only get cringe when they're taken to the hypercompetent lengths that you describe - it's the difference between making the character the author and making the character a character.