For "unintentionally hilarious death scene", I present to you Chapter 2: "Intensive Care" of Dead Space. You've just stepped off the tram and come upon a blinded and obviously traumatized-to-the-point-of-insanity female medic huddled over the mangled remains of a fellow crew member, ranting and raving about how she knew you were coming. She goes to hand you a kinetic module, letting it tumble out of her hands to the floor as she falls back, asking if she can "go" now. Her dying body slides to the floor...
...and then converts into a ragdoll model, and Havok physics takes over, bouncing her two feet off the floor like she fell onto a trampoline from the ceiling. Leave it to Havok to turn a moment of despondency and bewilderment into a lol-worthy situation.