CptSlapaDome

I'm not sure if this helps you, but browsing through the Collections here on Nexus may help you discover the types of mods you're looking for. Each Collection tends to focus on its own goal (game overhauls, graphic/lighting overhauls, ai overhauls, character overhauls, etc), and they each (for example, Next Gen Skyrim) have a "Mods" tab that you may click to view each of their original mods. Right now, I'm using a collection, but a few times a week, I browse the Collection to curate my personal list, and I hope to soon become knowledgeable enough to deploy my own list without relying on Collections. I hope this helps, and I'm sure the links may seem redundant, but I'm in the same boat as you, and I have yet to receive any answers, but the strategy I'm employing at the moment at least yielded an enjoyable and playable version for me, now I'm just aiming for perfection. Good luck, and happy gaming!