When my group does a LAN we usually try and fit in a variety of (older) games, but some tried and true are:
zDoom
Unreal Tournament (we prefer the original due to how the Translocator works)
Shadow Warrior (the original)
DotA/DotA2
Command & Conquer + Covert Ops
StarCraft (we do a lot of bug hunts, 3 players vs 4 Zerg AI (2v3 also works for co-op))
Warhammer 40K: Dawn of War + Expansions
Age of Wonders: Shadow Magic
Civilization IV
Now, if you want to completely ruin a LAN, take Roller Coaster Tycoon. Nothing better than a bunch of people all networked together playing an addictive single player game.