Not really. I have never been a big fan of Skyrim as I find the combat tedious, none of the story or side quests were interesting, and I just generally found the world drab and uninteresting to be in. So when you add mods to it, it's like putting sprinkles on a turd in hopes of making it prettier. Mods can't change the underlying problems with the game. At least not without a HUGE amount of work on the modders.
As is the case with all games with lots of mods though, play it without anything first to get a feel for how the game works. Once you have played it long enough to know what you hate about it then go looking for mods to fix those problems. Except for the nude mods. Get them first. Always.