This is actually kind of twisting my head around now, because I just sort of assumed - and maybe my brain filled in the blanks a bit since - that the N64 did have some RPGs worth playing, but I can't remember playing a single one.
All the people who loved RPGs above all from the SNES/Genesis days jumped to the PlayStation and to a lesser degree the Saturn.