Starcraft.
System Shock II does have coop with patches and such. Mods are also out there but I never messed with them.
if you like diablo try Titan Quest
Is this game abandonware yet? If yes, who wants to run through one of the greatest games ever with me?