I don't think judging the performance impact of one single mod isn't all that useful. It's more about how a whole lot of mods incrementally add up performance costs. Getting the optimal mod setup is all about how you choose to balance things. My rule of thumb is that you cannot run a stable game with both lots of graphics-havy and script-heavy mods.
What I do to balance out my performance is that I don't indiscriminately install all the highest resolution texture mods. For interiors I can go the extra mile with eye candy, but since exteriors are the most resource-intensive environments I generally don't install 2K resolution texture mods. 1K works just fine, and I think things like post-processing effects such as ENB more than weigh out the importance of hi-res textures.
With regards to script mods I am very careful about stacking mods that continuously run script at regular update intervals, since mixing those is the highest contributor towards instability and script lag. You'll have to gauge yourself what kind of mods work that way, since most aren't going to explicitly spell out how they technically work in the description page. A mod like Frostfall which is always checking temperature would be one such mod, and things like Locational Damage or Trade & Barter probably fall into that category as well. You'll have to be very choosy about what you prefer here to avoid overloading the engine (I don't think your CPU makes much of a difference in this case).