So here's my thoughts on Curseforge integration.
The main pro is free advertising for the game- as well as advertising for the mods in the game.
A secondary pro is that it gets a mod database going beyond what we have in the forums.
The main con however is that the way VS is setup- you can really only have one instance going on in one place at any given time.
On top of that, the twitch launcher will at times not load things properly as of late. (however, I think it's just minecraft getting that issue.)
I will say that while there could very well be better options- Curseforge will make the most noise about the game and having it on the twitch launcher (and with how lovely the logo is) will make people wonder "what's this game?"