A water spot is a mineral deposit. If it has sat long enough, it is an etch in the clear coat.
Columbus water is treated and leaves mineral rings when it dries on a panel, and a sprinkler run or an afternoon shower does the same thing on a parked car. This page covers which spots come off and which do not.
A fresh spot is a mineral deposit sitting on the surface. A decontamination wash or a light polish takes it off. An etched spot is where the mineral ring has already attacked the clear coat, and you can feel the edge with a fingernail.
The test: wash and dry the panel, then look at it at an angle in daylight. A spot that disappears with a wipe was a deposit. A spot that stays is in the coat.
Deposits: a clay bar or a dedicated water-spot remover, then protect. Etching: machine polishing, which is paint correction - $700 for a small vehicle and $900 for a midsize at Curbside Mobile Detailing.
Deep etching on glass is the harder one. Glass is harder than clear coat and polishing it takes a glass polish and time, and some rings stay.
Never let a car air-dry after a wash: dry it with a clean microfibre or a filtered blower. Park away from sprinkler arcs. A coating helps because water beads and runs off, which is exactly why coated cars collect fewer rings.
It removes fresh deposits and nothing else. Once the ring has etched the clear coat, only polishing removes it.
Etching that has gone through the clear coat is permanent short of a repaint. On glass, old rings often stay after polishing.
A decontamination wash is part of a detail; if the spots have etched, it is paint correction at $700 to $900 by vehicle size at Curbside Mobile Detailing.