Thought I'd throw Neverwinter Nights out there - it isn't on the same level as some of the other games here, but it's legendary because of its modding community.
There's more content for that game out than I know what to do with, and the initial Campaigns that come with the game and its two expansions are long enough to be enjoyable, even if you never download any of the user created content.
Bookmarks