Black diamond sand is popular but be very very careful about the grit. I tried to go that route. But my local tractor supply tried to sell me the fine (I think) even though it was listed as "medium" on their website.
The black diamond bags I bought and returned don't say anything about grit, nozzle size, "medium", "fine" or anything else that would let you know what size grain it is. There were checkboxes for nozzle size on the bag label that presumably one of them would be checked to indicate the nozzle size (grain size is measured by the size of nozzle needed to blast with it, bigger the nozzle, the bigger the grain), but no check marks - they sell blasting sand with no way to distinguish the grain size! They apparently used to sell a red labelled bag and a black labelled bag, one was fine and one was medium, but they don't do that anymore (or at least my Tractor Supply said that).
You'll see many posts on here and elsewhere of people accidentally using the fine black diamond and having a very cloudy aquarium for days/weeks. I decided against and it went with Seachem Flourite Black Sand for peace of mind. Substrate is a one time deal, so I ate the cost. The black diamond looks great, buying it is just risky. The Seachem Black Sand is gorgeous.