not for asthetic purposes at all. It's a great way to have a very low nutrient system. You can have tons an tons of flow for your sps, and also you can have enough flow where none of the detritus can settle on the bottom to rot, and is instead, picked up by your skimmer before it causes lots of nutrients. A successful one is always run with a very large skimmer.
my 10 gallon right now is a bare bottom because when i was moving it, the tank broke so i went barebottom isntead of isturbing the sand bed. On it is a deltec MC500 skimmer.