The big one is Halo on Xbox. We did multi-system LAN's like every weekend it seemed for years. With friends and their family, we routinely were doing 4 consoles to 4 TV's hooked up to play and with our settings, we would have CTF matches that lasted hours sometimes (No shields back in the day when the magnum was the best weapon in the game).
Another was Fatal Frame. A couple of us would rotate through the controls, getting super scared, but in the fun way. My friends place had a big 'ole subwoofer under the bed, so one time we didn't know it was on and up loud, so we were playing the game and get jumped by a ghost and that subwoofer shook the boomed and shooked the bed and made us a flip out. It was hilarious.
I also remember playing through games I normally couldn't as I didn't own a Gamecube, so I played stuff like Wind Waker, Animal Crossing, Resident Evil 4, and some others over there. I still remember how bummed I was losing my Animal Crossing memory card at their house lol