A couple springs to mind
Bruce Lee on Commodore 64, the first game I ever beat on my own. I was practically a toddler then and had to rely on my bro and sis to fire up the c64, but I managed to beat the game. I was so damn proud.
Silent Hill 2, forever the favorite. When you find out the truth about James' wife was such a powerful scene, not to mention how it puts your journey through Silent Hill in a completely different light. I don't think heavy themes like that have been handled like that since.
The Last of Us, the whole game is gold from start to finish but nothing beats that intro part. Me being a fairly fresh dad with a daughter of my own made it all the more impactful. Still can't play that part without bawling my eyes out.