Using the 'sand' type substrates you just have to be careful when working in the tank. Removing/moving plants, netting things out, etc. because the substrate is so light that it can get messy.
Mostly aesthetic challenges rather than biological or chemical challenges.
I have black tahitian moon sand (very comparable to the black diamond stuff) in a couple of tanks and it looks great and seems to grow plants just fine as long as I keep the tanks properly fertilized. I rarely mess with the tanks though so I don't have to worry about stirring up the sand.