Talking with a living god in Morrowind

Dying from a nuclear blast in Modern Warfare.

Every video in every Thief game.

The "red vs. blue" vault in Fallout: New Vegas along with most of the dialog in the game.

Bioshock's Andrew Ryan scene and it's world.

Half Life 2's world.

Fallout, Arcanum, Planescape and many other RPGs that focused on great writing.

Shooting your brother in the head at the end of FEAR.

Talking down a man with a hostage at the start of Deus Ex: Human Revolution.

Most cutscenes in Assassin's Creed 2.

The entirety of Mass Effect.

elder scroll oblivion, reading about the wolf queen and finding her tomb in skyrim

bioshock 2, after the daughter, it was one fun family warfare

That games artistic value sadly gets overshadowed by the commercial success and franchise it spawned. COD 4: MW is an awesome game. Which is exactly not an "America saving the world, HOOAA" game but quite the deconstruction of it.

I also want to mention the introductory sequence of that game. Very well done.

It was a much better game than MW2 and 3. Mostly because it was well-paced and built up to its shock moments while MW2 and 3 tried to be all shock all the time.

PST definitely has a lot of great moments. A couple of my favorites (spoiler's obviously):

- Morte's story about the man with three wishes in the Brothel of Slaking Intellectual Lusts.
- the revelation about the true nature of the Unbroken Circle of Zerthimon and Dak'kon's vow.
- the goodbyes to Dak'kon, Fall-from-Grace, and Nordom ... some of the most incredible dialog ever written for a game.

Another for me is in Homeworld were you return to Kharak to find it destroyed and you watch the blackbox footage of your planet being destroyed... hard hitting stuff.