Tyler,
You know you can ALWAYS just ask myself or Mike if we're available to dive with you. Since I work nights, it's easy to coerce me into a dive after 9am. Lake visibility seems to be better in the spring before boat traffic gets heavy, but it does vary from lake to lake all season. Here's my location suggestions in no particular order:
Table Rock: Moonshine Beach (swimming area or spillway) or Dewey Short (Army Corps station by dam); these will not require a boat to access. Some/most of these will require a boat to access: any of the sites at this link
http://scuba-sports.com/dive.htm Mike also has info on a low vis/near 0 vis cove if you want to learn how to dive in braile.
Norfork Lake, Arkansas: visit Jordan Marina for the beta on the lake
http://www.jordanmarina.com/diveshop.html Jordan Marina has a treasure hunt every year, I'm currently awaiting information for this year's event(s).
Beaver Lake, Arkansas: see Mike at Sho-Me Scuba for the gps coords, he's got the maps too. There is a cove with several boats, moped, chainsaws, manequins (that I've yet to find), 2 piper cub airplanes (1 of these is at the deepest point at roughly 50ft), and a helicpoter. The foundations are a good place for classes. Dui will have their rally near the dam.
Oronogo, Missouri:
http://www.oronogo.com/ Brian at work has first hand info on this site.
Bonne Terre Mine if you want to shell out the money.
Mermet Springs, Illinois: This is where the aircraft from the U.S. Marshall's movie is located. DUI usually does a DOG Days rally at this location near the end of the season.
Any of the clear-water rivers in Missouri like Jack's Fork, Current, etc. Just make sure it is not a direct spring branch so you're legal to dive it and be sure you're ready for a current/drift dive in cold water.
Stoney