Clear water is great for swimming and looking but not so good for raising fish because it is plankton (base of the food chain) deficient . The bottom is only part of the "clear equation" as you can have green water in a swimming pool . Soil suspension is one clouding event and a plankton bloom is another. A rock or clay or sand bottom does not preclude the second. So it depends on what you want.