They are fantastic at lowering nitrates once they get going - the anoxic bacteria populations can take a few months to establish. Where they fall down is misunderstanding and misuse. They seemed to work for most people for a handful of years and then the phosphate in the tank would start to rise. They were good at lowering nitrate for a long time. This got called "old tank syndrome" and many other things, but most people thought that they were releasing phosphate back into the water. This is not true... it is more complicated that this...
You have to understand how aragonite (sand and rock both) can bind massive amounts of phosphate from the water column. Hobbyists saw zero nitrate and very low phosphates and decided not to change water because they thought that they "did not need it." What was happening is that the sand was binding up all of the phosphate for quite some time and doing the job that the hobbyist was supposed to be doing with routine maintenance. Remember that there is a massive amount of aragonite here that can bind years worth of phosphates. What happened in about year 4 or 5 is that the sand got full and could not mask the lack of maintenance anymore and the phosphate levels started to rise to the point of inhibiting calcification, limiting algae growth (another false positive) and killing some types of coral. People did not understand why and the theories came out that a DSB is a "time bomb" or that the sand bed was "leeching" and some people abandoned their DSB.
The people who still did their maintenance or kept a fuge did not ever really have problems with their tanks.
Basically, the sand took the blame for the hobbyist.
I don't use a true DSB, but I do use about 3 inches. I like this because it will denitrify and I don't have to take up so much tank room with more sand. This is a safe way to lower nitrate and while it keeps mine very close to zero, it will not drive the nitrate too low with an overdose like Organic Carbon can - nature figures out the equilibrium and they are bosses at getting it right. I vacuum mine after year 3 or 4.... 25% a quarter for the next year. I also have conchs and a cucumber (that has split a few times) to keep it clean - they are fun to watch go to work. I change water and run a fuge and my phosphate levels stay low - with this approach the sand becomes a buffer for phosphate, not a reservoir.
What you are wanting to do is more of a remote DSB. If you add the word remote to this, then you can get all kinds of different threads. People liked these because they provided a safety net to just replace the sand without tearing down the tank to replace it. If you really want maximum denitrification, then look more towards 6" of sand.