The only time in recent memory I've felt kinda depressed after a game was Mass Effect 2, both because I realized that the great experience was over, and that I wanted to live with the consequences of my actions in the final mission. I lost a few people, and knowing that I could have done better...