One of the main reasons cheaters get hammered in Valorant and LoL, is how Riot use player performance data. If you collect performance on players - even over a short period of time, you can measure their average skill level.
When the skill level of a specific player goes from an average skill level of 500, to 3000 over the course of 2-3 games (because they started using cheats), there's little need to detect any cheat programs or aimbots running in memory, or whether they're using some funny controller - they're just cheating, and they get banned.
Same with CSGO and spinbots - the cheating is so blatant and easy to detect with automation, you don't need humans to review it or double check - just ban them.
They used to do this in LoL - where players would simply create a new free account, Riot stopping banning them and just had the matchmaker put all of the suspect cheaters, bots and hackers on the same server, worked a treat.