well, it all realy depends on how you like muck diving. Some don't take to it well and others like it as much as the clear salty stuff (no kidding). If you can find something to apreachate in muck diving then there are a fair number of spots to dive that are an easy drive and little cost.
Table Rock Lake
Norfolk Lake (spelling is wrong I am sure)
Beaver Lake
Tanycomo Lake
Stocton Lake
Truman Lake
Bull Sholes Lake
Palm Detere Lake (spelling again)
Lake of the Ozarks
Truman Lake
These are the major lakes around the area, they are clearly muck diving (pun intended) and some are the worst of the worst such as Lake of the Ozarks that one is a chalange.
There are also quarries that are not that far depending on depending on your roadwarrieor wortheyness and wether or not others are going that you can throw in with.
Mermet Il,
Hide,
Eldon,
Oornogo,
Rolla,
Bontere Mine (like a clear quarry underground, not a cave dive)
Most of these are town names as I can't remamber the names of the quarries themselves...
and some that are not well known. There is one (well three) on hwy50 just out side of Sedelia that I have been trying to find out who owns to see if we can dive it.
There are also some Springs such as Bennit Springs which I suggest everyone try, though it is clearly a cavern dive and don't enter the cave without training.
Ally Spring
Big Spring
Round Spring
Cave Spring
Can't remamber some of the others. some are cave and some are cavern and a couple of them are OW but none of them are a big dive as an OW.
Then there are some rivers that are good to float down and dive such as the current river. it is mostly fed from springs and as such is typically very clear. there are some spots that are say 20 feet deep from what I here.
none of this may be what you are used to and some of it seems silly (talking about taking scuba gear to a river for a 20' dive, but some people like it)
In general the dives around here (and I have discribed places within a couple of hours of kc to several hours away) are murky and cold. if it is clear it is cold beacouse it is a spring. if it is warm the water is static, deep or the lake just turned over and it is usualy merky.
I would suggest you not let any of this turn you off to muck diving but rather get with some people that are expierienced in the muck (you have a good start here. many of the posters on here dive weekely and are very expierienced) and just go diveing with open expectations and see if you can find something in it you enjoy.
If you have options on where to live based on diving I personally would suggest someware in the carabian. I dive where I live as opposed to the other way around. that is just until some great benafactor hands me a brand new sail boat. Then I will dive everyware....