I'm not looking for the home-field Cheater's Advantage here.. but can anyone direct me to some decent, updated Add-ons/mods?

I hear a lot of talk about them, tried googling it, Just a sloppy mess. But I'm going to be blatantly honest.. Nexus Mods site intimidates me and leads me astray.. Not only is hard to find what I want and what stuff does, but it's a real pain in the to find some 'Essential' features.

Any help?