Whether it’s glass or plastic, there are polishes for both that should remove water spots.
My wife decided to remove some bugs from the windshield on her SUV using scotchbrite and I polished those out using a silica polish, iirc, and a Flex polisher.
Plastic should be significantly easier to polish.