1. Counter-Strike: Condition Zero (single player game)
2. SIERRA Half-Life: Counter Strike
3. Counter-Strike 1 Anthology
These three are all the same game. Built on a 9 yr old game engine.
The community is full of cheaters.

Counterstrike: Source is what you want. It is part of the Half-Life 2 game.