A DSB is really best for new to the hobby, as it is part of your natural filtration. And I'm still running a tank with a DSB all these years later because I don't like the look of a barebottom tank.
DSBs denitrify the water. The rock can sit on the sand or be in the sand. Detritus can collect, but the microfauna in the sand help decrease its volume as they consume some of it. If there is an extended power outage, DSBs suck up the oxygen quickly, so it is important to have a back up plan to provide circulation.
Barebottom tanks allow for more flow. Rock needs to be placed on something like starboard (HDPE material like cutting board) to keep it from shifting and it helps avoid breaking the bottom panel of glass. Barebottom tanks don't help with filtration, and require the hobbyist to regularly siphon out detritus because it is an eyesore and adds to nitrate & phosphate issues.