First off, that's an incendiary thread title and an unfocused OP. Is it about paid mods generally, or the Creation Club specifically? This thread has cohered around the latter, which is definitely worth having discussion over, but that wasn't the best way to start.
So yeah, Creation Club. It's very different from Bethesda and Valve's Steam paid mods concept from two years ago, basically being a contract system for amateurs, with all of the oversight, restrictions and rewards that entails. It is a closed system. This inevitably makes it vastly smaller and less diverse than the full breadth of the modding community, and severely limits its influence on that broader community. The basic system of communal sharing the community subsists on can't really be threatened by this program because the major communal building blocks, things like script extenders, are completely opposite from the approach the Creation Club is taking. Still, there will almost inevitably be some amount of brain drain from the community regardless because talented members of the community will naturally want to partner with Bethesda, thus closing off themselves and whatever assets they create to the community, and that's unfortunate, but unlikely to be catastrophic. Personally I do also have misgivings about any entity taking amateur work and reselling it under its own banner without fully embracing the amateur creators, but that's a complex issue that we don't need to go too far into here.
The question that anyone that isn't either being disingenuous or has a direct profit motive is really asking in this situation, and the question the OP seems to be trying to address is
what is the best way to help the modding community flourish? The Creation Club, unlike the Steam paid mods concept, isn't even trying to answer that question. It's really not very innovative or ambitious. It's not an apocalyptic disaster like the Steam paid mods concept, but it's not a bold or at all idealistic vision for the future either. It won't have a large impact, but it will function as intended. The funny money currency is definitely bullshit though.
One more thing that people do not realize, that this can actually help modders. Why? Because contractors will ask for Creation Tool enhancement to make their project reality. If they will have some ambitious idea and current system will be really shitty at doing it, they will request development support from Bethesda and in Bethesda interest will be support them to finish their work.
Mod support has always and will always be in the best interest of any game developer, the Creation Club or any other system of dev/publisher payment for mods doesn't change this. This isn't an argument for the Creation Club's existence.