This was done including weapons from Nuka World and Far Harbor, but would probably be even easier to balance with just one, or neither of them. I set out to find the right mods to balance this and ensure that every type of ammo can by used by at least two types of weapons, and preferably three, while also avoiding redundancies wherever possible.
Unfortunately, the way weapons are distributed among these different types is pretty uneven, and many weapons are the only one to use the ammo of their given type. There are essentially four ranged weapon categories in Fallout 4 Pistol, Rifle, Automatic, and Heavy. I took some time, a while ago, to build an analysis of how weapons are distributed in Fallout 4 based on their ammo type and perk usage.