I'd recommend Final Fantasy 6 for the SNES.
It's got a very special atmosphere that just makes you want more.