Day of Defeat: Source

No question about it - easily the best fps I've ever played.

As for CoH, it's fine as long as you like micromanaging and having your tactics in part dictated to you (there's very little flexibility even in skirmish maps thanks the the supply system and it feels far too much like you're running around in circles for no reason, imo)