I'd have to say my favorites have been:
.: Fallout/Fallout II
.: (Sid Meyer's) Pirates (for both C64 and the new one)
.: Neverwinter Nights

All very good games, Civilization (the original); the Jedi Knight and Knights of the Old Republic series get honourable mention too.