There really is no right answer to this question, which is why it's always so hotly contested.
Sand positives:
- appearance (subjective)
- greater microfauna biodiversity (subjective)
- some fish & inverts require sand (objective)
- more light reflection, as long as the sand is white (objective)
- greater LR stability (objective)
Bare bottom positives:
- appearance (subjective)
- lower nutrient (objective)
- doesn't blow around (objective)
There's no doubt that bare bottom tanks are just easier to manage. No worrying about sand storms, so you can crank the flow to 11. No concern about nutrient build up or additional cleaning. You can even largely get around light reflection and add some protection to the bottom panel with white starboard or acrylic sheet.
For myself, I'll have a hard time going bare bottom. I just like the visuals of a sand bottom and find watching critters in the sand immensely entertaining. I also have some fish in mind for my next tanks that will pretty much necessitate sand.
The allure of the bb is strong though, for sure...