Totally agree. I was very disappointed with Homecoming. It was a new developer who did it, and they dropped the ball. 2 is still my favourite out of them all, though. Veeeeery atmospheric.
Other than that, when I'm really down or just frustrated, I love the mindless killing route. Killzone, Dead Rising, No More Heroes, games that just let you plow through enemies and show 'em exactly who's boss.
The Overlord games are pretty great, too. You basically play a Sauron-type figure in a fantasy world. Your goal is to take over the land and rule it with an iron fist. You also have countless gremlin-like minions at your disposal to do your bidding, or you can just take out a big battle axe and take care of business yourself. It was made to be humourus, and it is, and really fun to play, too.