As far as Final Fantasy goes, I liked the early ones, Final Fantasy IV, V and VI. I, II and III I didn't try (for long), even though there were some nice remakes. I played VII up to a point, but I didn't play it back on its day, I played it recently, so I don't know, I just got bored at Junon and gave up.
Some spinoffs are good too, like Final Fantasy VII Crisis Core and Final Fantasy Dissidia, but neither are good as RPGs, but as other genres. Crisis Core ends way too quick and isn't very free-roaming, Dissidia, well, is a fighting game with levels. Both are great but as RPGs are not the top choices, same goes for the proper series.
Final Fantasy VI, my favourite, has a great story, combat and progressing, easter eggs, characters, it has everything. Even still, there are better RPGs for the SNES.