Sorry its an old thread, but I just saw it now.
I've dove with the Holiday several times - well worth it. Aqua Specialists out of Rocky River always arranged "dusk dives" every year in August and some of September for every Wednesday evening. Good deal for fifty bucks, as you get one tank, a sub sandwich with a drink, and a trip leaving from deep in the Cuyahoga river, out to some near shipwrecks (not all that great) to mostly fun dives over the old cribs and thier rubble fields. One dive we did was over the shipwreck Austin, (I think), and my buddy and I missed the wreck but found a giant ship anchor 20 - 30 yards to the northeast of the wreck - an anchor so huge, I could swim under it in the opening under the crossbar.
They need six divers to sign up. I remember one time we went out and one of the DM's kept checking sites and all sites had horrible vis, so John Norris, (shop owner at AS), said "well, we can always do the Jacks", and since we all wanted to get wet, we anchored off of Burke airport shore which was made up of huge concrete "jacks" and the vis was really good between ten and 35 ft. Muddier above and below those lines. Fun dive with powerful dive lights.
Vis gets better the more east you go (towards NY), but I've seen 40 ft in front of Cleveland before. Late summer gets best vis after calm days. I take my own boat out to the stadium rubble reefs in front of Lakewood, and its decent, but I prefer Cozumel.