I remember a few years back playing Half-Life 2. I was at the part where the city pretty much has a war between the resistance and the Combine. After waiting for Alyx to open some gate, I was killed once I passed it. Upon my surprise from the game reloading an auto-save, I was still dead. Apparently upon getting killed, the game auto-saved and I was stuck just looking at some nearby buildings, all while the camera was on the floor. Such as funny bug that was despite the fact that it really sucks when you just want to go forward but you end up dead because you had to fight a bunch of Combine in a small area for a few minutes.