But something in real life is totally misrepresented in the game rules.
Yeah, RL is what we play D&D to escape from, so that's fine, really. ;P
The help action doesn't require a roll of any sort so it's always successful and never hinders the character being helped and that's just flat out wrong.
Yeah, it's a fairly rational 'gamist' decision. The player declaring the help action is using up his action, prettymuch sitting out his turn, and in return the character he's helping 'automatically' gets Advantage. That is a very steep price to pay, so if you want players to pay it, making it work 'automatically' (and Advantage is 'clever,' in a way, in that it seems to help more often than it actually does - unless you choose to differentiate 'your die' from the 'advantage die' by color or order rolled or something) is a pretty good idea. If there was a meaningful chance of blowing your action to 'help' and not being helpful or even screwing things up, it's that much less likely anyone would ever go for it.
Maybe you could use the additional d20 provided by helping to model this, story-wise, by having the helping player roll that second die, and then narrating the effectiveness based on who rolled what.
At least he'd be doing something. But it would eliminate that clever illusion (above) of Advantage being better than it actually is. Because the helpee would know that his helper was 'useless' any time his own roll succeeds (which is, in 5e, typically most of the time).
Like, if the helper's d20 was the only successful one, then he clearly contributed greatly to the other's success. And when both rolls fail, you could narrate that as the helper getting in the way like you describe.
Another trick I've started using is the group check.
Sometimes a player will try something, get a check, obviously fail, and then everyone else will pile on and try to do the same thing with the same check - someone, almost inevitably, will succeed, and off they go, making the whole exercise pointless (just narrate success & be done with it). So, instead, invoke 'Help' or 'Working Together.' Or, as I'd done in the past, if you're going to have everyone try to pile on with something, it turns into a group check, because you're looking for a consensus, and that consensus can be wrong, even if (only) one of you gets it right.