I love the look of white, pool filter, sand in the tank, but when I had it in my 60 gallon tank I found my fish never seemed to develop any color. On the other hand I had the best success with Corys using the pool filter sand, the grains were nice and smooth and the corys seemed to love that substrate. I switched to Black Florite Sand, I found it showed as much dirt as the white sand and seemed to discolor the water, additionally the bottom dwellers seemed to really dislike the florite, and I had to move the corys to another tank because the florite seemed to erode their barbels. I am now using Tropica aquarium soil it seems pretty good overall but I believe it adds a lot of organics into the system so I am on the fence with it now as well.
If I was to do it again, which I likely will, I would go with a mixed color sand similar to what
@PheonixKingZ shows in the picture above, though I would try to get something with rounder grains. Either locally collected or playground sand.
I do agree with
@Byron states about the white sands affect on the fish. I haven't seen a natural freshwater fish environment that has such a light substrate. Most fish receive comfort from dark areas, if the substrate is darker it seems to me that the fish hide less frequently.