I had a mix of sugar fine and "aragamax select" in my nanocube...it was mostly sugar fine though. My diamond goby got excited maybe once a month and caused a little storm, but for the most part it was no problem...even with an MP10 in there. We used 100% sugar fine in my girlfriend's 20long FOWLR tank that she had...with that shallow depth it was a nightmare, even though the tank only had an HOB filter and a pair of koralia nanos. It was extremely cloudy for the first few weeks, and the koralias basically had to be pointed up to keep it from blowing around.
I agree with what's been said...if you don't have a shallow reef you should be fine...otherwise you'll just have to wait for the tank to mature to crank up the flow. For the first few months with my tank, I had to dial it down a bit, but after a while I could crank the MP10 up to maybe 75% before it started kicking up sand.
On my new build I went with a much larger grain size. My one complaint with sugar fine sand in both tanks was difficulty in keeping the sandbed oxygenated enough. My girlfriend's tank had an army of dwarf ceriths and nassarius snails...but still had cyano issues even in a very lightly stocked tank (she did probably overfeed though, lol) My nanocube's sandbed was kept stirred by my diamond goby, but he wouldn't touch the area around the nem and I consistently had cyano there. I think if you stick with a 1" bed or less you probably won't have issues...but 2" has given me issues.