Almost all fluoride from the drinking water does not have any effect on tooth enamel, because it has contact with it only for a few seconds, except for an infinitesimal fraction that may exit again the body in saliva.
On the other hand, the harmful effects of fluoride in drinking water are certain and it cannot be predicted exactly how much water will be ingested by someone, i.e. which will be the harmful dose of ingested fluoride.
The only argument of those who support water fluoridation is that most people must be morons who cannot be taught to wash their teeth. I do not believe that this theory can be right.