For me it comes 2nd to FFVII. I don't think whether it is memorable or not really has much to do with the game itself, but to do with how much the game meant to you at the time of playing. Of course a well designed and interesting game world does indeed help.