My #1 has to be that ghost from LA. I know it's just a very low-res 8-bit game with very little text and character development by today's standards, and it's just in a dream, but that one is an "Awww"-moment which gets me every time. It's as touching as a gameboy game can possibly be.
Others...