well wabbajack works with nexus (You just buy one month for autodownloads) but I guess that'll have to change

Modding community will never allow it, when Nexus allowed people to keep downloading old mods a bunch of authors decried it since they wanted the ability to remove a mod from the internet forever. It was 'theirs' (even though it's just modified Bethesda data)

I found a couple recommendation lists to "make the game look good" because I dont need all the fancy extras like body mods and weapons and grouped them together in load order, because I knew at some stage I could just package them nicely into a ZIP if I need to uninstall Skyrim for some reason. Glad to see I was ahead of the game

It really depends on how one is applyng mods. Bethesda does have their own mod site and in-game support for modding, and that's pretty straightforward (and the only option on consoles). That will limit what mods are available.

I do kind of wish that there were one cross-platform open-source universal "game mod" program that could support multiple online services. Would like to have Wabbajack-like functionality (apply a whole set of curated, tested-together mods) as a base too, as that'd lower the bar.