Chrono Trigger, Morrowind (Oblivion can shit right off, I like Vvardenfell too much), Earthbound.
I've tried to like the FF series, I really have, but there always comes a point at which the tight, well-paced, dramatic plot I've been sucked into just falls to pieces and you spend hours wandering around until you happen accross a solution. FF6 and 7 are the worst offenders for this, I think.
Edit: the only pen'n'paper RPG I can be arsed with is Dogs In The Vineyard, because it's so very narratist and involves precisely zero faffing about looking stuff up on tables.