Recently picked this up again, this time on XB1, to see how good the console mods were, and they were way better than I expected.
The mods I currently have installed:
Modern Firearms - Adds loads of real weapons (mostly rifles, SMG's & shotguns) and incorporates them into the game by having most NPC's use them, have them lying around in place of vanilla weapons and having vendors stock loads of them. Every weapon in this mod is really well done, each being fully customizable (even more so than vanilla weapons) while also making gameplay harder due to their increased damage over vanilla weapons. They're also levelled, so you start out seeing just AK's but you gradually start seeing MP5's, M4's, G36's etc and even start seeing M82's and MGL's at higher levels.
Fallout Commander - Lets you call in backup soldiers from any of the factions in the game, ranging from recon squads to power armor soldiers and air support.
Pistols - 4 seperate mods that add 4 different pistols to the game (M9A1, P99, Desert Eagle & Colt 1911), each with a great deal of customization.
Rifles - 2 seperate mods that add 2 semi-auto rifles to the game (M1 Garand & MK14 EBR), each with huge levels of customization.
Mix 96 Radio - A simple radio mod that adds some of the greatest music tracks from the Fallout series
Awesome Mix Vol.1 - An amazing radio mod that adds Peter Quill's "Awesome Mix" from Guardians of The Galaxy. Amazing music for when you get into a gunfight.
WRVR Companion Mod - What at first seems to be a simple radio mod also adds an incredibly good companion. The radio station is so well done, I actually prefer it to all of Fallout 4's vanilla stations, the host is really good and there's a good selection of period correct music, and the companion is brilliant, featuring amazing voice acting that is just as good as that of the vanilla companions.
Realistic Sound - Not a huge mod, but one that greatly increases immersion by making alot of the games sound effects sound much more realistic than normal.
There's a few other smaller mods as well but these are the main ones I always have installed. Together they really make FO4 feel a lot more realistic and more immersive.