If you ask me, there are no cons to having sand. All pros. I bought 40 lbs of cichlid sand for about $60. A few days later I had my son at toys r us, and they have reeeaaalllyyy nice whiteish sand. Lowes only carries quick krete which I find only comes in a boring brown. So check the toy stores first, I feel like you may have a little more color option. Just my theory!
And that's IF you go play sand route.