I've been running a DSB, specifically a Jaubert system, forever. My ocellaris clown is 29 years old, so I'll offer that as evidence as to whether it works or not. My nitrates & nitrites are always zero. Phosphates are very low, difficult to measure, as I also run an algae scrubber. I also run a skimmer. And have a refugium. Cyno is the one thing I still struggle with.
I do vacuum out the top 1 cm or so of sand once or twice a year, and replace it with sand that has been cleaned and dried. The trick is to have more sand than you use in the tank. Same way with rocks. When a rock gets ugly, I remove it, and replace it with one that has been "cleaned." Cleaning means that the rock spends 6 months on the peak of my roof, enjoying the sunshine and rain. Then back into the tank. Let nature do the work for you ... not chemicals.