Thanks for the detailed response! I'm 100% with you regarding any online/interpersonal cheating. I think I understand your sentiment too regarding solo play. I guess that with mods I sort of have the attitude that they represent an acceptable mutually beneficial customization. It's like devs putting down an amazing baseline, which you can tailor just a little to yourself. You can do this in a way that devs could never do to precisely suit the tastes of thousands of individual olayers.
I know some games/devs encourage you to use mods. In these cases, I feel that they enhance the original intention. That said, mods can also absolutely breach the intention of a game as you described. It's a bit situational.
So I guess I see where you're coming from and its a totally valid take. I believe that in some cases the "original" version or vision actually endorses mods, but devs do need to be conscious that not everybody wants to engage with mods as a concept. Some assembly required can be a bug, not a feature.