It depends on what game and what particular bad mood I'm in. I've found Guitar Hero to be a great little depression whacker when played with my roommates, more because of the antics we get into rather than the actual game itself.
Stress? Bring on the zombies, Left 4 Dead. Bring those mealy-mouthed corpses on.