It is hard to argue with how good a bright white sand bed looks, but after having tanks that had just disgusting sand beds I will be hard pressed to ever have one again. When coral get big it's hard to access the sand for cleaning, and I figure if your sand bed is so dirty you wouldn't feel comfortable stirring it up, not just what you can reach but all parts, then why have it? With bare bottom all that detritus just isn't there. I don't feel that with our little cubes of water we can create any real benefit using substrate that won't eventually turn into a liability.
Most people don't like the flat bottom look, but there are ways to get around that. Put various size rocks around in key spots (fist size for a medium tank), maybe covered in zoas, or zoas between the rocks. It breaks up that hard plane look and still allows a lot of flow to keep detritus suspended. You don't have to go crazy with rock everywhere, but just a few can really help.
I notice a lot of people talk about "natural" when discussing sand and BB. But there are plenty of coral reefs that have rock substrate, no sand. If you can find pics of those and try and incorporate them in aquascaping perhaps more would be happy with the looks. Really a rocky bottom is more "natural" than sand for many of our systems.