I've had several in Oblivion. Like the HOLY SHIT MY TOP HALF IS ROTATING INWARDS ON MY LEGS one.
And once I had a really helpful glitch. While fighting the Village Leader on RE4 (and due to terrible choices and poor luck i had no money and just a Red9 with one clip of ammo to fight him with) and I was having a pretty tough time. Luckily, after killing his spine with a grenade I found, I climbed to the loft and waited for him to lunge at me. Instead he hopped up on the loft, his spider-limbs ready to create rape-holes in my thorax, and...
...He froze. He just stood there, twitching. So I shot at him with my Red9 till he died.