Well, let's see....
Chrono Trigger
Chrono Cross
Xenogears
Mario RPG
Beyond Good and Evil
Mario bros 1-3, world, yoshi's island, 64, and galaxy
DKC 1-3
Zelda LA, LttP, OoT, WW, and TP (started but never finished Zelda 1 and 2)
Prince of Persia
Beyond Good and Evil
There are probably a few games missing from this list, but I don't think there are very many.
I guess generally I tend more towards more action-y games and get bored before finishing RPGs, but obviously there are plenty of exceptions.