I guess it's the combination of a frustration of losing matches and the constant suspicion. I was constantly trying to probe things and watching replays, it ruined the game because I was always focusing on cheating.
Ultimately, I think most CS players don't really care about subtle/closet cheaters, so as long as they don't feel it, it's fine, the game keeps its high player count, so it's a good facade and valve is happy with that.
CS is a game I can really enjoy, until I couldn't anymore.