kinda depends tbh, there have been instances involving people opening several hundred hacks at the same time, and it doing nothing, or it banning you for a little ESP...
Though this will normally happen due to it being outdated, or the particular game.
I am assuming you are referring to VAC anti cheat :D
VAC isn't a good anticheater. You can confirm that playing without prime and you'll see hackers everywhere. VAC don't ban the player immediately. that's the problem of VAC. They can ruin your game and when they get ban they just create another account because the game is free now so it's impossible to play cs go without prime.