dungeon keeper 2 is very good game indeed. I also like all lucas arts adventures, indiana jones, monkey island, say grim fandango... and those old strategy games like warcraft and dune 2 (though dune 1 is also very good kind of strategy-adventure).
only game I play nowdays is empire total war, napoleon, but it takes ages to complete. usually I just play custom battle to relax. since its against computer, I choose double less units to make it competitive.
I used to be very good at warcraft2,won a tournament once. I have aoe gold
Starcraft battle chest, warcraft,war3 and diablo chest.