I've kept DSB's on all my tanks for eons now. You want the sand stirred, but not by sticks, by little creatures that dig around in it constantly making holes and pathways and moving the grains around a little bit at a time. You want amphipods, bristleworms, and maybe a cucumber if your tank is big enough (200+).
You specifically want to stay away from sand sifting gobies, or blue linkia starfish. Yes,they do sift the sand, but they do so, because they want to eat all the microfauna that lives in the sand making it a functional bed. A sandbed in a giant sized tank just cannot keep up with a goby, they will wipe it out. Same with mandarins.
The point isn't just to move the sand around, the point is that you want it moved around, and filled with life. Sterile stirred sand is purely decorative.
As for the H2S volcanoes, I think that is a myth. I guess if your bed was completely sterile, and compacted, and never moved for years, it might do that, but I've never actually seen evidence of one existing.