I tried a couple of play sands and did not like them one bit - one was a drab grey color, and the other was quite sharp. However, there are a lot of people that do like play sand so perhaps its a brand thing.
I prefer pool filter sand (featured in my avatar) - great color (from the 3 brands I have), great weight (too heavy to be sucked up in the filter or vacuum) and it's soft. However, some people have complained about the color of their PFS, so again, perhaps it's a brand thing.
The best sand I've ever used was the caribsea supernaturals sunset gold. Beautifully rich color, very soft and just heavy enough to not be a problem for the filter. Only downside is it's at least $1/pound (20 lb bags) - not such a big deal with small tanks, but it cost me $100 to fill a 4 foot tank.
125 - BGK, chanchito cichlid, pictus cats, silver dollars, palmas bichir
125 - cichlids (severums, bolivian rams, chocolate), rainbows ( turquoise, red), loaches (angelicus, zebra, kuhli and horseface), plecos (BN, RL and clown), denison barbs, tiretrack eel, pearl gouramis, betta
90 - Congo tetras, african knife, upside down cats, spotted ctenopoma, kribensis, delhezzi bichir
2.5 - betta