Dental fluorosis is a long-existing public health issue resulting from inequitable access to potable water. Socially disadvantaged rural communities in fluoride-endemic areas, where a conventional irrigation system is absent and groundwater containing natural fluoride is the predominant source of drinking water, face a significant oral public health threat. This study aimed to determine the association between water fluoride levels and dental fluorosis. A systematic review aligned with PRISMA principles was conducted using the SPIDER search methodology and relevant keywords on many search engines, such as Google Scholar, PubMed, Elsevier, Sage, Web of Science, Cochrane, and Scopus. This review sought to ascertain the PICO model’s application as a search strategy tool. The reviewers gathered and assessed 1164 papers from January 2010 to January 2023. In total, 24 research papers from diverse databases were included. Using the Newcastle–Ottawa Scale, grades resulting from several data screens were evaluated. According to a previous systematic review, there may be publication bias in studies examining the association between fluoride in drinking water and dental fluorosis. The findings of this systematic review indicate that subpar fluoride is detrimental to human health. The author outlines legislative tools and technological advancements that might reduce fluoride levels.