The saddest games for me are the Gears Of War games. Carmine dies, Dom finds his wife.. but she is soo messed up and scarred that he had to kill her, then Dom dies. :(
Well I would say, every Mass Effect game. Especially the ending because you know that it will be your last moment with the crew because you can't free roam after that.