Hello Brummy and welcome to Kansas City and to Scuba Board. Judging from your profile it looks like you have lived and dived in some rather interesting places around the world.
Most of the dive shops in this area have regular weekend trips to either Table Rock Lake in southern Missouri or Beaver Lake in northwest Arkansas from May through September.
I have not been to Table Rock myself, but I did my OW certification dives at Beaver Lake. The diving is decent by Midwest standards - 20 foot vis on average, but this can vary depending upon the time of year and recent rainfall activity. Like all inland lakes, there are thermoclines as you descend. Actual water temps vary significantly depending upon weather conditions and time of year. Any LDS in this area can give you an idea of the current conditions because they have divers in these lakes almost every weekend this time of year.
The only mjor problem with Table Rock or Beaver in my opinion is distance. You are looking at 4 or 5 hours driving time one way for either of these lakes.
Cheers,
Loiret
