I haven't really done any nasty river diving, but have been in very low viz. I find that if it's less than 2 feet it's probably not worth it. A powerful light helps, but not all that much. If it's 1 foot you can get right close to the bottom if you're looking for stuff, but can't see much anywhere else. Of course, unlike in a river, little or no current is a big help.
you want the current to remove the sediment you stir up.....no current you will be hopelessly lost in a matrix of silt