My earliest example of gaming stupidity, there have been many since, was on The World is Not Enough on the PS1. There's a terrible stealth section where your only given a stun gun because no one at Black Ops Entertainment had thought to give the player a silenced pistol, you know because 007 never ever uses such a weapon. Anyway, I start off thinking "well the enemy AI is crap enough, I'll just wait till their alone, stun 'em then move on." Two problems with this plan; 1) they would WAKE UP after a few minutes and 2) the game would usually make you backtrack through the levels. The first time I turned a corner and ran straight into a guard that shouldn't have been there, I was convinced I had just missed him. Restart level, go the same route being extra careful, it happens again.
I'm 10 and I'm screaming with anger like I do now with COD it was that infuriating, however that's not the stupid bit. I refuse to play it for a while, come back to it 2 years later because Nightfire came out and had a similar stealth level. Again, the stun gun didn't make the guards stay down and out of pure anger I punch one guard while he's stunned expecting a game over for killing a civie. No game over, guard's body vanishes. I'm now thinking "Well there's no way that would work with World cause that's PS1, no way would they have thought to do that."
They had.
I completed that level on my next attempt.
Finished game and promptly destroyed disc.
I hate Bond games.