Good topic, as I am looking right now too.
Garnet sand is my most unique substrate, it is a great color and also works good, clean and needs little rinsing. As a sandblasting sand it is widely available and also in different grit sizes.
CaribSea Naturals lovely material but it was basically white, though they have many different colors and types of substrate. Their products are really nice.
They have one which is called Instant Aquarium which you put in with no rinsing at all!
There are other sands available at the sandblasting sand distributors. Should all be pretty clean becasue of the use of them.
Petco sand as Fresh mentioned it was good but the color of the black eventually wears off a little and there are some grains that are a little light. The one color was like orange bronze & also the blue held up well too
Used Quikrete construction sand and it was pretty nice but kinda dirty. It was nearly white and it drove me crazy when I started in planted tanks because even plants let off bit and particles which litter the substrate and I used the same vacuum for the white sand tank and the black sand tank, and it would drop little black grains on to it which was too much trouble to try and get out.
Eco complete - kinda sharp but holds plants in place pretty well.
The one you mentioned in your first post popped up on my radar and it was available at a far away lfs.
Amazonia is supposed to be great, but I haven't used it personally though a neighboring hobbyist said that it took about 6 weeks to finish the ammonia leeching from it. Which I have read the same experiences echoed across the reports ~5 weeks seems to be pretty common.