Being the standard magazine for the harpoon gun, there are no notable effects.
Weapon modifications will modify an existing weapon, and any modifications previously equipped on the weapon will be destroyed, not unequipped. Loose mods cannot be crafted.
Known by default
Standard harpoon (1)
Craftable at any weapons workbench.
A loose mod exists in the game files, but cannot be found in-game.