Counter-Strike. Half-Life mod. And it rocks.
Q3 I'm pretty good at (IMO) but can't play it until Nvidia fix their drivers with regard to Punkbuster compatibility, and I'm not downgrading the drivers because they're really good otherwise.
CS is pretty damn realistic though. Terrorists versus counter-terrorists in a number of scenarios, purely online game.