I roll bare bottom mainly because it is soooo much easier to clean and I have heavy flow in my SPS dominated system. I considered large substrate to help it from blowing around but the larger it is, the more detritus it can trap. I have a melanarus wrasse and it seems pretty happy and it's certainly fat. I do agree that sand looks much better, especially if you have minimal rockwork but I disagree that barebottom is generally ugly. IMO if you run barebottom your job is to take attention off the barebottom and keep everyone's (including yours) eyes on the corals/fish/scape. Like I said this is more challenging if you have a minimalist aquascape. When other aquarists see my tank for the first time, it takes them over 15 minutes after looking at it to notice that is barebottom. I think that is a good indicator that my barebottom has little impact on the appearance of my tank. I should say, however, that, while I don't have just a pile of rocks, my tank is far from a minimalist 'scape. Good luck. It all personal preference as many have stated.
EDIT: Forgot to say that the outside bottom of my tank is painted white, but this doesn't matter anymore since it is covered in coraline. Also, I have an unlit DSB in my sump for filtration purposes..