It's basically true that 99.999% of mod campaigns are "autistic drivel."
The thing about mods is that only an autist has the time, focus and drive to come even close to finishing one, let alone maintaining it.
I've made two or three mods in my time, and I only sort of maintain one. And none of them have been more complex than editing a few lines of code.
My Stellaris mod made headlines around the world, but the truth is, if they'd just left it alone instead of banning it, I probably would have forgotten about it and no one would have heard of it anyway.
So, nearly every significant mod will suffer to some degree from the author's autism, because the author has autism, almost every time.
For example, The Witcher 3's "Enhanced Edition" mod is fantastic and makes the game non-linear, but the author had some dumbass idea that Quen would electrocute the user if he even touched water - which makes no sense, since if it behaved like normal electricity, it would dissipate into the ground while on dry land. So he wrote a script into the mod to kill the player whenever he even touches a puddle. "killplayerforlulz" I think it's called. I know because I edited it out by hand. And despite being able to customize almost everything else, this is the one thing you can't edit, and he repeatedly refused to change it.
And then there's our own Drog Blacktooth and his constant meltdowns, despite being probably the only great Arcanum modder/patcher. And he wasn't even the most autistic. If anyone ever played the "car mod" for Arcanum, they'll know what I'm talking about.
So, the next time someone says "mods will fix it", keep in mind that what they're really saying is "hopefully some autistic lunatic will waste his time fixing the thing I paid these other lazy trannies for".