i agree to Korowa's suggestion to terranigma.
i also agree to Range's suggestion to shining force series and phantasy star series
i absolutely LOVED phantasy star 4. one of my favorite part of that game is the macro function. you dont have to use a weighted item on your button (and on turbo) to accept the cursor on fight. only once in awhile (dont tell me i'm the only one who does this when leveling up characters

) but also, with the right combination and timing of the character's spells, you can create combination spells.
for the sf series, i also have shining force cd for my sega cd. i love the characters, but it's not walking around and finding items like 1&2.
you should also try Tales of phantasia and seiken densetsu 3 (aka secret of mana 2)
if you like the action/fighting game, try the streets of rage series.