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.