There is:
https://forums.overclockers.co.uk/showthread.php?t=18703761&highlight=fallout+mods
Nexus currently has almost 17,000 mod files for Fallout 4 and only about 2,000 of them are mostly nude women with unfeasibly large breasts
There are a lot of mods like that, but there are a lot more that are less tacky and silly. I run with 71 mods active, only 2 of which change gameplay (to stop Preston's endless quests and to stop the silly attacks on settlements that somehow require you to personally defend a walled settlement with dozens of turrets and 20 heavily armed settlers against 6 raiders with pipe guns).
Perhaps the one I like most is the mod to stop the display on your Pip-boy being deliberately bad (flickering, scan lines, etc). A little thing, but it makes a big difference to using the Pip-boy. There are a lot of small useful mods like that.
There are also some full DLC level mods. I'm playing Tales of the Commonwealth at the moment and all the extra areas, NPCs and quests are so smoothly integrated into the game that it seems like it's not even a mod.