Final fantasy 7 , zelda ocarina of time, portal 2 ,MGS 1 elder scrolls skyrim Resident evil 2 ,mass effect 2 golden eye 007, castlevania symphony of the night chrono trigger super Mario world ,half life 2 and RdR need I say more ?
But krec, you can't just list a number of random games . If you're comparing something, it has to be judged with specific criteria that's shared in common with all of the games that you're comparing. In terms of emotional impact (which I'd say, qualifies as one of those criteria), all that FF VII had going for it was Aeris's death. And aside from MGS 1, the rest of the games that you've mentioned have cardboard characters with very little development.
I'm in the process of getting the ps4 I'll be playing the last of us soon enough.
No doubt, it'll be the best version yet with 60 fps frame-rate.