It happens especially for big games because there is an incentive to write cheats for them in the first place. Look at CS, COD, Apex etc. there are a lot of cheats and cheaters and seemingly nothing they can do against it. Meanwhile Cheatdevs stopped writing cheats for BF 2024 (the latest Battlefield) because the player count was too low. Now what most games do is use something like EAC or Battleeye that scans your PC for cheats, which is generally built into the client. Game dies? Now they have to remove it. With what dev resources? Yeah...
The bigger issue for games in general (especially SP) are services that are required to play the game, which means that when (not if) hose go away mean that you can't play the game anymore. Player data stored on a server instead of locally (because microtransactions, remember the days of editing save files?), Games for Windows Live, GameSpy, etc.