For the "cheats" part, I think that was primarily included for Gwent, as any sort of botting or exploit would obviously give the guilty party a decided advantage over other players. I really don't see a case where someone mods a single-player game so that they have god mode or unlimited ammo...and a studio goes after them. It wouldn't matter. What would anyone claim the damages are? There would be no case. For any multiplayer environment, there would certainly be damages. A strong argument could be made that it would be upsetting the in-game competition, creating an unfair/abrasive environment for what was created as a sportsmanlike challenge, and driving off future sales.
So no, I wouldn't worry about modding Cyberpunk or the Witcher however you want in terms of "cheating". It's an SP game. It's meant for a single person to enjoy their time. Make it as difficult or easy as you'd like.
_______________
For the "don't be mean end" -- you bet. If someone was to make a mod that introduces any sort of hostile view toward a real-world group (race, gender, politics, etc.), that sort of thing would now be directly tied to the game in question. A studio would have every right to say, "We will not allow our IP to be connected with that." Freedom to mod a game does not mean freedom to break laws with it. Law still applies.
In this sort of situation, I think the problem would not necessarily be the creation of the offending content; it would be the distribution of the offending content. That would be the same thing as posting a big "FU" sign on the sidewalk in front of a restaurant. Yes, it may technically be on "public ground", but it makes the restaurant seem connected by association. That could prevent people from comfortably using the establishment and detract from sales or generate interruption of business if people off the street came in to complain. And, it's wholly non-constructive. The law would almost invariably be on the side of a private business to have the offending content removed.
It goes right back to the tenets of most law: Your rights are your right unless they infringe on the rights of others.
Everyone has a right to speak their thoughts, but no one has the right to force others to hear their thoughts. And no one has the right to interrupt the intended purpose of a business to further their own personal politics on a subject. They need to find the appropriate forum. Another person's IP is not an appropriate forum if the thoughts in question are hostile/destructive in nature.
So, yes, I would imagine a studio in that situation would legally be able to say, "Take down that mod; we're not going to be associated with that sort of message."