From what I have read, white sand will show all the fish waste. Unless you plan on vacuuming the tank frequently ! I have also read that black sand does the same to some extent.
I swapped both my tanks out to Quickrete all purpose sand. It has a much broader color range and size differential and as stated above is very cheap. 50lb @ $3.95 from Home Depot. I am real happy with the look and function of this all purpose sand. The fish seem to like as well.
Again it is all up to you and your preferences. Good luck !
FWIW - I liked the black best...