I certainly do understand the frustration modding brings, particularly in how much overhead you have to go through to get them to work. While I understand the frustration, I think "making it more easy and streamlined" is kind of missing the point of the whole thing. Modding in Bethesda games is NOT done poorly, and while yet often many third party utilities are needed to get multiple mods to play nice, this in my mind is actually a GREAT thing!
Why?
Well because they didn't water down the modding experience, this isn't Neverwinter Nights where they give you a fairly basic toolset to make custom adventures. No in Bethesda games you can literally change everything, and I do mean every little thing in the game because the developers gave mod creators the same tool they used to build the game proper. This means that mod creators can make vast sweeping grandiose mods that drastically alter or improve the game, and yes at times break it horribly, and the fact that Bethesda gives us these powerful tools capable of BREAKING their own game is a big thumbs up in my opinion because that level of freedom and power also is what allows mods to be so robust and game changing.
While other critics I hear also bash the "offerings" of these mods as being low quality or appealing to a more demure "teenage boy" crowd with it's nude skins and warcraft swords, I would simply counter by saying these people have never actually LOOKED into modding properly. You go to the Nexus, the best hub for mods out there, and if you have an idea of what you want, you will find an amazing amount of VERY high quality mods that fit into your game perfectly.
Yes it's a bit stressful and time consuming to get some mods to work right, but once they do, the amount it changes the game is simply amazing. With just 2 mods, Dragon Combat Overhaul and Deadly Dragons you can take the feared wyrms of Skyrim from petty annoyances that guards can dispatch without your help, to terrifying behemoths you can't survive a single full breath attack against, which in my opinion makes the fights with them so much more intense. Hiding under bridges or behind stone columns to avoid being roasted alive while guzzling nearly every potion in your inventory just to stay alive is how a dragon fight SHOULD feel.