Guild Wars: myself a flame elementalist (as was my main's typical spec) and a few others were frantically trying to kill waves of something (Charr?), but it was one wave after the next and we were slowly getting overrun... [end of record] I think this was before I had seen the canyon scene in the recent King Kong film -- gods, that was horrific. (And now it occurs to me that the latter could serve as an (external) metaphor for cancer...)
There was also one where rookie myself and one other, my friend and captain (no one I actually knew), were two warriors in some sort of labyrinth/ruins place fleeing from a couple minotaurs (again, of the Guild Wars variety). We split up to separate them and she manages to kill or lose one. We then rejoined, and she decides to cover me while I climb to safety ahead of her. I get halfway up and look back to see her fending off the other, but then watch helplessly as she gets fatally skewered through the gut by the thing's unicorn horn. [end of record] Sort of a Qui-Gon Ginn moment, I guess (heck, is there a trope on this?), including how they didn't die instantly, but you knew it was pretty immediately fatal.
I've probably had others, but those are the only two I can remember.
edit: I suppose you could psychoanalyze the content of game dreams, which strikes me as odd (but then I never cared much for psychology of that sort).