what game(s) did move you like none other?

Portal 2

Saints Row 2,3 and WOW 4 !!

Planescape: Torment. In my head, the friendship between Dak'kon and The Nameless One became the stuff of legends. :-)

The emotional punch at the beginning of Homeworld was also quite good.

And, of course, "Papers, Please!" I've only played for it an hour, but that's enough to know I haven't even plunged its depths yet and it can only get more involving.

The Deponia trilogy

I've got many: Neverwinter Nights, both Deus Ex and Deus Ex Human Revolution, S.T.A.L.K.E.R. - Shadow of Chernobyl, F.E.A.R, Max Payne 2, The Suffering Ties That Bind, Dead Space 2, Half Life 2, Return to Castle Wolfenstein, Unreal 2 The Awakening, Metro Last Light, Medal of Honor Allied Assault, Bioshock 1 and Infinite(not 2, certainly not 2) and, of course...the game that dismantled the whole "war is cool" bullshit idea that those idiotic Call of "Dudy" games instituted, Spec Ops The Line. But if I had to chose just one, I'd say...oh boy this is hard, guess it would have to be Bioshock. People who gave obvious answers like Mass Effect or Dragon Age or, even worse, mentioned pieces of shit games like CounterStrike or Call of Duty Modern Warfare 2 are shallow and narrow minded idiots who probably enjoy Michel Bay movies and have no idea what a good story is.

Crisis Core

Shadow of the colossus

and since when CS:GO has a story?

So far, I guess Max Payne 3.

Arkham trilogy.

Spec Ops: The Line.

Mass Effect till the 2.
I still have to get into Spec Ops The Line (won here on sg, yay!) and Brothers (waiting for better sales).
Also I finished Thomas Was Alone and it did make me immerse in its atmosphere a lot. It's incredible how so few resources can transmit so much.

Soul Reaver 2 (also 1 to know the start of the story and defiance to know the end), games can't have a better story, ever.

Guess there are 2 of them. First, original Bioshock(ohh,that Would you kindly kill moment, of course). And second one will be Sleeping Dogs. I wasn't expecting good touching story from it, but it for some reason really hit me into the heart.

The Last of Us. Amazing Game, Awesome Atmosphere and just an epic Story!

Brutal Legend (Im kinda fucked up)

the walking dead R.I.P Lee

KOTOR 2 ---> Scratch the Disciple and you have a game where pretty much every character is awesome.

Mass Effect Trilogy ---> Feels abound everywhere you turn!

Star Wars: Republic Commando ---> I'm still coming to get you back Sev! Somehow...

There were others, but these three were the best for me.

The Walking Dead, and Alan Wake.

Wow... There are so many.

I guess the earliest one to have a big emotional payoff would be Ultima IV. Then there was the unexpected ending of Diablo. Of course, Planescape: Torment was huge, emotionally, and the Baldur's Gate series had me pretty invested in it, too. There were a lot of mads for Neverwinter Nights that were tremendous, too many to list here, and then there are a bunch of games which others have already mentioned.

I suppose I would have to say that, out of all of those, PST probably had the biggest emotional impact on me. I'm quite looking forward to playing Torment: Tides of Numenera.

Heaven and Hearth coz the wilderness was deadly and rewarding in equal parts and your friends and town(s) were your most precious good

Im a permadeath believer ever since

BioShock Trilogy in this order: BioShock Infinite, BioShock, BI: Burial at Sea Ep. 1, BioShock 2: Minerva's Den, BioShock 2. But all of them are great.

System Shock 1 and System Shock 2. So immersive.

The Witcher series. Books are far better but still amazing stories.

S.T.A.L.K.E.R. Shadow of Chernobyl. Comments not needed.

F.E.A.R. 1. Original story of the Alma was played brilliantly.

Dust An Elysian Tail, mass effect trilogy maybe deus ex Haman rev.

Spec Ops: The Line.

The Longest Journey, Dreamfall, Baldur's Gate 2, Walking Dead, Max Payne games

Tetris, 'nuff said.