Sand choices, opinions wanted please

[Edin508]

Kkeller416 sent me a PM in my search for a Red Sea 260 and it looks like we have made a deal. When I went to look at the tank he is currently using a very coarse crushed coral as a substrate. Well, I would like to change it out to fine sand instead, personal preference. Has anyone found that some brands are better than others? They all claim to be some sort of live sand, but I don’t buy that, how could that be? Anyway, are some better than others? Better washed with less cloudy than others?
This tank move is already going to be tricky as is with live fish and corals currently in the tank. I am going to try and transport a bunch of the water and refrain from cleaning anything until it has been up and running for some time to make my best attempt at shocking things as least as possible.

 

[Neilnde]

Following

 

[Chris A.]

Tropic Edan has been the cleanest of all the sands I’ve ever used. The live sand is just a ashes sand with off the shelf bottles bacteria. There’s no way to get the grains to separate if they were wet lol

 

[this is me]

I've been using the CaribSea Aragonite Special Reef Grade Sand since my last two tank large display tanks and a variety of Caribsea sand in the past.
https://caribsea.com/aquarium/
For display tank, I don't like the sand to be too fine, ie. Oolite sand. The flow required for SPS will endlessly blow the Oolite around. Sand in the display tank is mainly for sand dwelling critters like leopard wrasse I like to keep. Therefore, I don't need it to be deep. My sandbed is ~2" in the display.
Be careful with sand that are too large. They're more likely to get coralline on and it'll look dirty in no time. I always see tank with large crushed corals have pink/green coralline covered the substrate.
My recommendation for sand in display is Special Grade Reef sand at 1.0 - 2.0mm grain size for SPS dominant followed by AragaMax Select at 0.5 - 1.5mm grain size for mix reef with minimal SPS.
I would use the Oolite and Aragamax Sugar-Sized at 0.25 - 1.0mm grain size for deep sandbed in the fuge with minimum flow.
If you want the sand to clear up quicker(and maybe cycle quicker??), they have them soaked in ocean water in the bag. But it costs about twice as much. I've used the wet bags in my smaller tanks but I didn't want to pay for it in the larger tank so I went with the dry stuff. Been too long to remember if there's any difference in cycling time. But to me, a newly set up tank will go into the "ready to give up" algae phase regardless until it gets cleared up with or without your intervention. I have not found a way to set up a new tank or a tank transfer with new rocks without algae showing up a month or two later on the rocks and last about 2-3 months. Most people will feel like giving up including myself but you just have to tell yourself it's just a phase.