The issue I have with this is that that 90% of those mods actually don't add that much to the gameplay. Do you really HAVE to play as a nude character? Do you really need a pink hello kitty power armor? Skyrim has a few really great mods, like the city expanded mods and the interesting-npc mods. Those are the ones that I feel can really add a lot fo Fallout 4.
Some people like "fucking around"-games where they don't take anything seriously and just wanna have a good time. The nuds mods are for those that want to pause every once in a while to have a good time spelunking their underwear for treasure. Whenever I decide to play Fallout 4 I'll be doing the same, just get a ton of ridiculous mods and treat it like the playground it is.
That is probably the only way to really not be ridiculously disappointed with the game. Unfortunately, however, there is no mod in the world that can fix a game that has awful writing, it can only make a bunch of distractions to hopefully let you forget about it.