Not to say these two are my favorites but two that I know of the moment I saw it.
When Jean Luc Picard time travels back in Generations, there should be two Picards running around!
^^^
But that's just crappy writing isn't it?
My all time favorite is the Stormtrooper bumping his head in Star Wars.
This. Especially because you can hear it.