Counter-Strike Condition Zero Deleted Scenes is basically the single player campaign that Counter-Strike Condition Zero should already have included.
The story might not be really deep or anything, but consists of various scenarios in which you’ll play any of the CT units and have to take down various terrorist groups. Like the original game, some missions also have you defuse bombs besides just killing enemies, but mostly it's just your average single-player first-person shooter.