What about the explosion at the end of F.E.A.R. (and you ought to add the same explosion from a different perspective at the begging of F.E.A.R 2 to the list)
the fallout one is pretty cool...considering how u can see mini versions with the fat man (or shooting cars...paying a price of a couple rounds of ammo =/...) haha but thats the price to pay if you want that sight without the fear of jail!
explosions are sick expecialy if there are people in them (I kno its messed up, but you know thats why you like them too). Its funny seeing people flying through the air like ragdolls. A good example? Fallout 3, dozens of frag/plasma/bottlecap mines, and an unsuspecting victim. (Youtube:"Fallout 3 40 mines on tour")