tinyE: Memorable doesn't necessarily mean good. Just saying. :P Personally I'd love to hear some digital game horror stories.
Way back in the early to late 90's, during a period that consoles weren't quite sure where they were headed yet, I set down my Genesis and SNES controllers an began PC gaming starting with Doom II.
Towards the end of the reign of the PSOne I turned my back to PC gaming completely disgusted by the patching process and Pool or Radiance and Ultima Ascension which were the last two straws.
Once console gaming also started moving into that nasty realm of hard copy alphas with intentions to patch, I figured I may as well move back to PC again because, at least, the games were much cheaper and everyone had evolved past that era of collecting physical things.
So this is just from memory of my past three years experience since I turned tail from consoles and ran back to the PC.
Spinorial: I'm just going to assume people are overlooking
Portal because, well duh, it's
Portal, so it's a given :P
In all fairness, I got Steam just for that game, and to this day, I haven't encountered a more outstanding game, in the most literal sense of the word. You all probably remember tons of moments from it, whether you care to admit it or not ;)
Story and dialogue-wise there has been a massive improvement since many films of the nineties and early two-thousands. Unfortunately many will never experience these much more progressive and sophisticated ideas and writing simply for the fact that they are too intimidated to learn anything that requires more than an Atari 2600 joystick to operate.
I've been playing Max Payne 3 recently and had it only been a movie instead it would've never caught my attention the way that it has.