I agree, Pete .. That death was definetly a memorable video game moment for me.
It was also exciting to crawl under cars with the enemy passing a mere metre away when I was a sniper in super-camo with twigs in my helmet. I'm very much looking forward to see what MW2 will bring! From what I've seen on commercials, there's even action taking place in space.
edit :
Looks exciting to me.