For me there’s pros and cons on both sides.
I’m a big fan of sand, but may setup my new tank BB.
Most people choose sand for its aesthetic appeal. It can also house some very beneficial critters (worms, pods, mini stars, etc) as well as pets like gobies, wrasse, shrimp, and larger starfish. It can also help with denitrification when the bed is 4” deep. Although even with just a little over 1” you’ll observe a little gas being formed.
Bare Bottom tanks allow you to direct the flow at the bottom of the tank. Or you can simple put powerheads on the bottom and blow across the tank under the rock work. You can also increase the flow intensity. Detritus is easily siphoned out. The tank runs cleaner, because there’s never really a build up over time. Encrusting corals can be grown on the bottom. Not a lot of maintenance is required after the initial 6-12 months.
I’m kinda caught in the middle. I’m not a wholesaler so getting a 1/4” more SPS growth with higher flow really doesn’t appeal to me. Just about everybody you talk to likes the look of sand and some of the most impressive reefs have sand. I’ll probably end up going BB to try it out. I can always add sand later down the road.