I've played Half Life1/2, Halo, Call of Duty2, and GTA Vice City/San Andreas, but I also enjoy Rail Tycoon and most by Sid Miers, especially Civilization 3/4. Always ones you come back to.
I can't say I use them to vent anger per sa, but they are good for letting out frustration when things don't go right elsewhere in Real Life. Curently I'm doing WOW after getting bored with EVE, which was a shame 'cos I'd rather wanted a good MMPG space sim.
And they cancelled the Star Trek MPG they were making

, so vented on WOW
Most of my friends play the online shooters, especially Call of Duty 4 on the Xbox, and I would say they have no violent tendencies whatsoever in the real world.
When playing the games, however, I wouldn't trust them with a blunt spoon!