I used to play Condition Zero alot..Its got single player but it was really the 1.5 of CS. Came out when Source was pushed back forever. Was hyped up to be revolutionary but game really just squized all the detail it could out of the old Quake engine. Looks really good still actually. Here is a comparision I did of dust 2.