I'm very tempted to say that Tales of Symphonia sort of works in that variety, on the GCN and PS2 I think. It had a fantastic plot, deep characters, plenty of interaction, much to do, had hours of gameplay, and yeah, it's an RPG.

Because Neverwinter Nights didn't make it to anything but PC I believe.