I enjoyed final fantasy tactics and FF tactics advance alot. I also enjoyed tactics ogre. Are there any other games like this out there? For the SNES there were a lot of great RPG games, just be warned some of them are going to cost more than you'd think...for example on Chrono Trigger and FFVI, I recommend getting Chronicles and Anthonolgy for the PS1.
SNES:
+Chrono Trigger-also available on the PS1 on the game Final Fantasy Chronicles
+Super Mario RPG
+Final Fantasy III (but its really VI)
+Breath of Fire
+Earthbound
+Harvest Moon
+Secret of Mana
+Secret of Evermore
PS1:
+Final Fantasy Anthology-Final Fantasy V & VI
+Final Fantasy Chronicles-Final Fantasy IV & Chrono Trigger
+Legend of Dragoon
+Final Fantasy VII, VIII & IX
+Final Fantasy Orgins
+Arc the Lad collection
+Dragon Warrior VII
+Harvest Moon: Back to Nature
GBC:
+Dragon Warrior III
+Dragon Warrrior I & II
+Dragon Warrior monsters II: Tara's adventure/Coby's Journey
GBA:
+Golden Sun (I & II)
+Fire Embelm
+Kingdom Hearts: Chain of Memories
Hope thats enough to get you started!