I have dried up silhouettes of what was previously water drops on my hood, roof, etc. I've seen some recommendations but can you recommend something that worked for your car?
Don't over think it. Just pick any of the brand name product lines and go with it. Meguires, Mothers, Chemical Guys, Griot's, are just a few examples. You really can't make a bad choice with any of them. Your only mistake would be using conventional car wax instead of using a polymer sealant or one of the ceramic or graphene sealants. As I said, I use Rejex and love it, but any of the better known brands will do just fine. I'd start by purchasing a claybar kit and seeing whether that gets rid of the water spots. It probably will, but even if it doesn't you will want to claybar before using a sealant anyway. Aside from a good sealant, claybaring is probably one of the most important things you can do for your paint. I have used both the Mothers claybar kit and Griot's kit and both work equally well.