I remember this one glitch in Fallout 3 where a dead enemies body completely spazzed out after I shot it with the Missile Launcher.
And in skyrim, the floating mammoths...
Few other games, I managed to fall out of the map. Croc 2, DMC4, Sonic Heroes, Fallout 3, Assassins Creed 1.
There's heaps more but I can't remember them all.