I agree that the people who do it for a job have more reason to cheat. You get almost nothing out of cheating in games for recreation.
On occasion, I used to play on servers that allowed cheats. When I played with them, the experience was interesting at first, but inevitably got boring very fast. In the end, all you do is remove the work done to generate good levels and turn it into a super-flat experience where your ping, cpu, and possibly your actual aim/weapon skill matters. If there are auto aim or other weapon hacks, there isn't even the weapon skill.
So, it gets boring. Especially against other people with the same hacks. It is probably marginally more entertaining when you are playing against people who don't have hacks and don't know that you have them.
However, ultimately, what is the point of playing a game if you don't actually play the game? There are people out there who enjoy trolling, but I can't see that being as interesting as trying to beat other people on a well-designed map.
Getting hacks is easy, although using them covertly is dangerous due to VAC and possible bans. For all of that, it's just a waste of your time, other than perhaps to understand a little of the mechanics of how the game works and how hackers might be using hacks on you.
Even if you don't do it professionally (i.e., compete in tournaments) you can still benefit financially from the cheats.
So that's a good motivator - you obviously cannot play in a controlled environment like the final tournament, but if you can get "up there" in the local tournament, you can end up being a local celebrity and get various low-level sponsorships and other things. Do it well enough that you make a name for yourself so you can get on YouTube and get paid for videos on topics not related to what you're cheating in and you're in a good spot.
You may not be able to get the $5M grand prize in a tournament (that requires work), but you can probably make a half-decent living on sponsorships, content sales and other things, without doing too much, either.