In short if you are using the right anode material for the conditions you can not overprotect. But if you use the wrong anode material you can overprotect. Magnesium in saltwater is overprotection. Zinc in freshwater is under protection. Aluminun alloy offers good protection in both fresh and salt water.
Not quite true - you can "over-protect". I have no idea where BoatUS got this info but as with all generalities, this one too is misleading.
Keep in mind that the zinc will CREATE electrolysis (favorable electrolysis since the zinc is being eaten up). Putting zincs where they were not needed will still cause the zincs to erode away since they create the battery situation where none may have existed.
The range of protection a zinc can supply to other metals bonded to it is limited by the conductivity of the water. In salt water you get coverage for a radius of about 4 to 6 feet. A zinc on the stern of a 14 ft boat where everything is bonded is only protecting half the boat. This range gets even less in fresh water and may reduce to only inches. Often magnesium is substituted for zinc in fresh water to provide an even higher voltage to push through the fresh water.
Aluminum in salt water is essentially useless as it's effective range of influence is inches.