If there's any good mods for it, I'm all ears
Kind of depends on what you want, really. I'd definitely download Mart's Mutant Mod RC 4.0.
FOOK adds a ton of weapons, ammo and armor, but I believe the latest version is quite bugged, so I'd stay away from that.
Fallout Wilderness Edition (FWE) is an overhaul that supposedly "Adds more realism", but all it really does is just lower your stats, AP, damage etc, so combat takes a lot longer. I guess that's considered "realistic" nowadays.
It does add some of the classic Fallout weapons back to the fold (such as the Bozar), so that's cool.
The Darnified UI makes it actually look like a PC game, rather than a console game for blind kids, so that's definitely recommended.
FOnexus does a great job of categorizing everything, so if you want new weapons, or a house mod, or new followers, just skim through their database.
Creston