With all the moving I have done over the past 10 years I've now had the opportunity to try several different types of systems. Personally, I've not had any nitrate problems with any of them - barebottom, very little substrate, about 1" of sand and a 5" DSB.
I've gone in a big circle and I'm back to a barebottom setup after my last move.
I don't particularly like the look (not that bad actually, once it's all encrusted with stuff) as much as sand, but it makes maintenance really easy and it's really nice to have lots and lots of flow without having sand blowing around. It's amazing how much detritus comes off the rocks every week with a turkey baster and I just don't have a lot of confidence that my sandbed could "process" all of that stuff. I prefer to remove it manually (ie. syphon it out with a small water change each week).
One of the biggest arguments
for a DSB is its denitrifying capabilities. Personally, I've not had a big nitrate problem with or without a DSB, so I don't really see that as a huge advantage in my case. I know they work well for some, but I don't think I'll bother with them in the future.
IMO there are many ways to be successful in this hobby. I think it just boils down to what you're comfortable with, what you want to do for maintenance, what sort of critters you want to keep, etc.
JME/JMO...