Personally, Neverwinter Nights (the original with the expansions, not Neverwinter Nights 2) was the best game for this sort of thing.
It allowed a DM enough control over the game world and the adventure, while allowing the DM to develop content that was always available, and could run...