Almost cried: Metal Gear Solid 3, Metal Gear Solid 4, Red Dead Redemption and Final Fantasy VII
Cried: Final Fantasy XIII, Metal Gear Solid
Cried like a bitch: Crisis Core - Final Fantasy VII
So basically, my list is made up mostly of Metal Gear Solid and Final Fantasy games which I found very emotional. But none of them are on the same scale as Crisis Core. I don't know hell the hell Square Enix did it but the game was emotional all the way through, it just built you up the entire game and broke your heart at the end. That game is a masterpiece for its story alone.