Zelda can be quite good, though I've only played the N64 ones. The Legend of Zelda: Majora's Mask is possibily my favourite game of all time, for a vast number of reasons which I won't go through at the moment. This is also the only game I've completed and unlocked/opened/found every single thing I can think of - that was years ago.
I also played and completed (though not fully, like MM) Ocarina of Time. It was very enjoyable. Not on par with MM though.

I like Star Wars: Knights of the Old Republic II: The Sith Lords. I never liked the original for some reason, it seemed pretty weak. Again, I compelted the Sith Lords. I'm not keen on the strategy to defeat a lot of opponents, which is essentially running away from them, turning, zapping/shooting, and running away; if hit, running behind aptly placed columns so the enemy literally forgets they are fighting you, which gives you unlimited time to heal, regain the force, plan out attacks and things. Even on the final boss for the game. Basically, better combat all together would be nice.
I enjoyed Morrowind for all I played of it, which, in terms of percentage, was possibly minute but I eventually became bored of the game and it's many faults.
I completed Fable, and thought it was rather entertaining, I honestly cannot play it anymore without driving myself mad. I'm also not keen on the possible exploits in the game; both to get an uber character after the arena and the house/trophy/money trick.
Pokémon was quite fun for what I played of it, but I can barely remember any of it - it was years ago and only the original Red version.
I've never dipped into Final Fantasy, and I can't think of any other RPG I have played.