White Crest Beach, Cape Cod stunningly gorgeous, questionable water

When I saw this beach I felt like I'd seen it before in a dream, or like it was the kind of place that someone might have described to me, late at night in a bar somewhere while I said, 'I have to see that, I have to go', with real yearning. You can't quite get it from the picture, but to get to the beach you go down a steep hill of sand. So it's like a beach that's also a mountain, or at least the side of a mountain. I found it to be very magical. Unfortunately, the water was brown and full of seaweed and smelly. I'm curious if this was an unlucky day or if it's always like that.