Generally, the higher the SiO2 content, the more spotting seems to be an issue. (At least so I've read.)
Beading looks nice, but I think beading is particularly bad for the paint. If the car is dirty or if the water beads have higher mineral content, that stuff just stays on the paint, and when the water evaporates, the minerals are left behind. Depending upon the acid content of the water and the level of resistance, some coatings are just prone to spotting. It's not a good look.
Many coatings need toppers to add to the hydrophobic nature.
In my opinion, the best coating/topper combo gets the water OFF the car and doesn't bead.
All the water spot removers do something to the hydrophobic qualities of the coating. I'm not sure what it is, but I've seen it ruin the quality of the coating with many water spot removers on several coatings.
I'm not sure if it degrades the coating itself, but I assume that it must on some level. SiO2 will break down with acid. I'm just not sure to what degree. Clearly, however, the performance of the coating suffers after using a water spot remover - so much that you need to put a topper on after using it.
(Sent via my mobile device...)