Valve just released Counter-Strike: Condition Zero which is available now via Steam.

If you pre-ordered your copy of Counter-Strike: Condition Zero (CS:CZ) over Steam, first restart Steam then double click the CS:CZ icon in your Steam Games list to begin playing. Those who did not pre-order the game over Steam can purchase CS:CZ at any time.