Not sure about the fauna in fine sand vs coarse sand. What I can say, however, is that I have medium grain substrate in both the DT and the refugium, maybe slightly larger in the refugium, and I have 2 dragonettes and a 6 line as well as a dotty back all fat and happy eating off whatever fauna grows from there. The SPS are also growing like gangbusters, but not sure if that's just because of the light and water and less because of the fauna. Rotifers and pods will also thrive within the macroalgae bush, eating off any phyto that grow there. You can also build what some call a "pod condo". Essentially it's small to medium rocks piled up into a tower in one corner of the refugium where there is good flow. Talking about flow, I am a little concerned about your sump/refugium design. Both inlet and outlet from the refugium are in the lower third, potentially leaving the upper 2/3rd with low flow. I would built a rock wall across the middle to anchor some of the macroalage variety you're considering, like red gracilaria. This will dissipate that flow upwards and around it, as well as act as a habitat for fauna and as part of your liverock system.
BTW, where are you putting your skimmer, or are you going skimmerless?