Fluoride in drinking water has no effect on IQ or brain function, long-term study shows
(twin-cities.umn.edu)
Eh the first major study in fluoride, the Grand Rapids study would never hold up to today’s standards. It was not a blind study and cavity detection is subjective.
Also drinking water is a poor way to deliver fluoride. The mechanism of action requires physical contact with your teeth to work. Toothpaste and mouthwash would be a better option and reduce consumption. To my knowledge, there hasn’t been a modern large scale study conducted looking into different delivery methods. We do have some evidence comparing countries that don’t fluoridate but still have low cavity rates.
And while rare, fluoride allergies do exist.
It can also be difficult to dose.