Generally speaking, big tides stir things up more. When you have to dive a day with a large exchange, aim for the latter part of the flood as ebbing and low tides are typically poorer.
When the vis in central sound goes to crap, head over to Hood Canal. Due to its much milder currents the plankton layer stratifies, so you may descend through horrible vis into nice clear water below*. Again, diving at high tide means that layer is 10-12 ft higher and that can make a huge difference at sites like Octopus Hole or Sund rock, where much of the structure is fairly shallow.
*bring a light, as it can be almost as dark as a night dive when its that thick