Unfortunately with the upcoming FO4 patch in a few days, a lot of those mods are gonna be broken for a few weeks/months. Bad timing by Bethesda on that front.
The show caused me to finally buy FO4, and so I immediately hopped onto Nexus and downloaded the highest-rated mod collection for the game. It has over 700 mods, so something tells me I won't actually be playing much of the game for a while yet. (I wouldn't deign to play a modern Bethesda game without mods.)