I have sand in my frog tank. Waste generally stays on top of the sand and is easily removed by siphoning or netting. I agree a bare bottom tank is not aesthetically pleasing.
Sand can ruin impellers in filters.