I squeegee the water off whenever I'm done but later on it still has that foggy water look. How do I get the door to look actually clear?
Used dryer sheets work well too. Wet, scrub, rinse. Takes off hard water stains and soap scum as well or better than vinegar in my experience.
Whenever you do get it clean, treat it with RainX or similar. We do that every few years and squeegee after each shower, our glass is spotless after 10 years. Our water is super hard too, saw the house next to ours which was built at the same time, disgustingly opaque with scale.
Use this, without any product, every time you finish to shower.
*removed externally hosted image*
Get some proper cleaning supplies and use them, there are specific bathroom cleaners that will solve the issue. Here in Sweden, I look for stuff like Ajax and Cif.
I've taken to using Dawn dish soap and the washcloth I use to wash dishes. It works great.