As Ltstanfo said, it does begin to clear up deep... I saw that change somewhere around 110 to 120, where it typically clears. However, for a quarry, Blue Water has pleasantly good viz, even shallow, unless the crap has been kicked out of it, by classes.
You won't feel the depth change, however, you'll certainly know you're down there when you hit that last thermocline. With all due respect to seaducer, whom is apparently used to the arctic conditions of NJ, it was still a shock to me when I hit that 58 degree thermo. Even with a 5mm full, and 3 mm core warmer, my butt turned brittle that first time.
Add to that the probability that you'll be somewhat narced at 100 ft., and the viz will be reduced until it clears a bit deeper, you'll be dealing with a few new sensations... Additionally, there's no direct descent line where they typically do the deep dive, so you'll be doing a free descent/ascent. Also, you'll have no point of reference the entire descent. Important to watch your gauges. However, these are all reasons for doing the AOW Deep Dive -- to expose you to all those conditions, so they won't come as a surprise in future dives.
I've only done that dive twice at that quarry, and have no desire to do it again (I don't drysuit dive, and I don't like the cold). I much prefer the 78-82 degree water at 90 to 100 feet on the Spiegel.
You may want to practice by the school bus, which lies at about 70ft. There's a descent line (from the bus to a surface buoy). The viz is typically around 15 to 20 ft. at the bus, but it'll give you a taste of the cold (not quite the last thermo), the viz, with a reference point, and no narcosis.
P.S. Once you go to Blue Water, you won't want to go back to Lanier...