All three have their pros and cons.
Bare bottom is easy to clean, and doesn't trap detritus but you should have a high flow throughout the tank to keep things suspended in the water column so that they can be removed by your filtration. They tend to look less natural than tanks with sand, especially when you don't have a lot of coral growth. Additionally, some animals require sand (i.e. some wrasses, blennys, snails), so you wouldn't be able to keep these in a BB tank.
A SSB won't help with your filtration, but looks more natural and is only slightly more difficult to clean, although as mentioned, can trap some detritus.
A DSB will aid filtration, as it will trap detritus and nitrifying bacteria will convert toxins into less dangerous compounds. It also allows you to keep animals that completely bury themselves in the sand. A DSB over time will benefit the tank, but comes with a big price tag. If a powerhead falls, rocks shift, or anything disturbs the sand bed, toxins can be released and your tank will crash. (Ask members that it's happened to.)
If you're ok with the look of a bare bottom tank, plan to provide the proper flow, and don't mind skipping some animals, it's not a bad option.
If you want to be able to keep a wide range of animals, with moderate maintenance, go with a SSB.
If you're an experienced reefer, want to keep animals that require a DSB, and are confident that you can avoid disturbing the sand bed, consider a DSB. That said, the DSB is a throwback from an older method of filtration and with improved skimmers, GFO and additional methods of nutrient export, I see almost no reason to risk the potential damage it can do.
