I have used washed/screened construction sand in all my tanks which cost about $8 per 100 pound bag. I've used all grits, coarse, medium, and fine. Medium my favorite becasue it deep cleans easiest, course sand my second favorite becasue its the most natural looking but hardest to deep vacuum becasue the grains are heavier.
Almost without exception I deep vac my sand every water-change in all my tanks and never-ever have the slighted issue with silt clay cloud blooming. In fact becasue I wash and boil my sand before use, my largest new 210 tank I boiled all my sand for had absolutely no diatom bloom becasue the seeding diatoms contained in the sand where they seasonally live and await water for bloom reproduction are all killed off by boiling. I can reach in and disturb my sand anytime with no clouding at all.
As far as nitrates are concerned, my Pothos nitrate filters take care of that problem converting nitrate and a whole host of toxins into plant growth.