Invasion RPG
It's not a total conversion modification like Red Orchestra for example, but I personally think Invasion RPG, configured in a balanced way, along with other mutators for it, such as different monster packs, is about the best thing to happen to the first-person-shooters (on the pure action side) for a long time.
It's just pure, raw action and fun, it's chaotic, and non-stop rush.