Don't listen to anybody here saying blanket statements without actually providing credible data to support their thesis.
Below is an article link that shows vanguard lead dev Paul Chamberlain tweeting how the anti-cheat heavily relies on the player base submitting cheat reports -which approximately 97% players DONT do . Paul continues to say there's likely a vast amount of current cheaters unnoticed by vanguard who are not subjected to manual reviews because they are not flagged in the first place via player report.
https://www.sportskeeda.com/esports/the-hacking-problem-valorant-why-cheaters-going-unbanned-riot-s-tactical-shooter
As for bypassing the HID ban, it is not that difficult to find various spoof methodologies online. There are private communities in forums dedicated to cheating evasion. Apparently, its common for coders to test the efficacy of their new script and code at local libraries/ Internet cafes. Some of these people even go as far as to purchase new pc components only to use the return policy loophole to renew their pc hardware for free after they are banned. One comment shows a user 'Rainman116' proving they have been banned multiple times and still play the game. Said user also uses a 'stream proof' cheat for Valorant essentially hiding the cheat software menu from stream/recording services such as Youtube or Twitch.
https://www.unknowncheats.me/forum/valorant/407497-ban-evasion-methods.html
One can also manually change their own HID although I'm personally unfamiliar with the complexity of this process. This video instructs how to do it exactly.
https://www.youtube.com/watch?v=ZF4aKydAcSM&t=189s
In conclusion, I would not trust the 'general consensus' regarding cheater frequencies categorically by rank, as even Riot admitted themselves, there are many unknown cheaters not accounted for.