I found this online and I share the same opinion: If you are diving at the inlet to a bay or river, generally the slack tide near high tide has better visibility, since the inlet will then be filled with water that has come from the ocean, which generally has better visibility.