The letter at the end of Silent Hill 2 always gets to me. I also got really weepy at the end of Shattered Memories too. Oh, and Okami, for it's rather cheesy ending, still managed to make me cry too.
BUT I'm probably the biggest crybaby ever so saying that a game made me cry really isn't that...