Foods and water already have enough Fluoride in them. For tooth paste, just about any tooth paste will do. The physical act of brushing your teeth contributes to a majority of the cleaning while the paste is for replenishing your apatite crystals. Flossing is also important.
So there is a clinical relevancy to having an over ingestion of fluoride which does lead to Fluorosis. However, this happens only in one of two cases where either the city messes up their ratio(should be 1 parts per million of fluoride to water) or if you get your water supply from a well and you are not aware of how much fluoride is leaking into your water supply(which is what happened in Utah). The thing that’s most upsetting about links that people will always post is that they have no actual links to scientific journals or studies. Those links just show the effects of too much fluoride.
However, topical fluoride or even regularly ingested fluoride has been proven to decrease the permeability of enamel. It does this by replacing the hydroxyl groups in your Hydroxyapatite crystals(what makes up your enamel) thus forming more hydrogen bonds which increases the strength.
Quite honestly, it doesn’t make a difference to me. I am ethically obligated to inform you that fluoride is good in caries prevention because there’s studies that support it. However, you are free to exercise your autonomy. If people and their children want to avoid fluoride like the plague then that’s more caries for me to fill.