diablo 2 lod
Depends on the system;
N64 was ruled by The Legend Of Zelda: Ocarina of TimeI loved Wind Waker for the Gamecube as well.
As for MMORPG, I liked Everquest and Dark Ages Of Camelot a ton.
ff7 is my favorite single player one
lineage is the best mmorpg cuz its free if you do it right!