Stuck in wall bug is nothing compared to "sudden punishment in hell" -bug (gta vice city and san andreas) where you walk happily at the street and all the sudden the earth engulfs you and you fall into eternal fall of abyss.
Another funny bug was with legendary driving game Driver. Especially in pursuit mode (lot's of cops) when you drive your car in specific angle to corner or wall and another car hits you, your car might take a sudden jump to sky, lasting sometimes over 20 secons, leaving black trail at the sky.
This was hilarious way to try to reach areas like building roofs and other inaccessable areas.