I don't play CS that much but afaik aimbots are there as well. I know that it has manual reports/user review systems so I imagine VAC is not effective as an automated tool
Counter-Strike has a bunch of anti-cheat systems, but they solve different problems (VAC, Overwatch, Prime Matchmaking, and VACNet). These systems all work together and I'd say it's pretty effective. TF2 could do with the same.
But my original point is that you don't need Kernel based spyware to do anti-cheat.