Starcraft LAN parties were always great.

Halo LAN parties are also right up there, for me. Made some good memories, even found a team for a time. We did local tournies, never anything big, but it was always fun showing up together at a party and get to face off against each other.