In short: Condition Zero is the container; Deleted Scenes is the hidden jewel inside that many people miss. If you only play one, play Deleted Scenes for a unique experience. If you want standard CS gameplay with bots, play the main Condition Zero mode.