Paid mods is almost never a good thing for the game itself.
Almost every mod out there is addressing some (real or perceived) deficiency in the base game. Good game studios look at what’s popular and either pull those features into the base game, or work with the modder to do the same.
Adding a paid mod system changes that cooperative relationship into an adversarial one, where modders see their revenue stream attacked by the game maker.