A bot for Counter-Strike has been released called CSBot. This is an alpha release so actions will be limited. Still, might be worth checking out. Thanks Erik.