I'm not sure I would even consider pool filter sand to be a "sand" per se even though the definition is that the grain size can be up to two millimeters. In an aquarium, pool filter sand acts more like a very fine gravel and can be treated as such.
You could also try Quikrete Medium Sand if it's available in your area. That has a slightly smaller grain than the pool filter stuff and has a slightly tan/light brown color. Very natural looking.
I'm not sure about the filtration thing, as I am only about to try the really fine play sand/repti sand mix in a few days. I'm going on a theory however that if I turn off my filters during vacuuming (which I tend to do anyway) then by the time I get them back on, any potentially damaging particles would have settled back down again. I wouldn't think any of the really fine dust-like particles would do any damage to a canister filter. I don't know this for sure; I just don't see how it would.
People have suggested keeping Malaysian trumpet snails in sandy tanks because their burrowing will keep the sand bed consistently churned for you. Plus I am of the opinion that snails are beneficial in a tank if you don't overfeed the fish and keep their populations under control.
Live plants should do great in the pool filter sand or medium sand. I grew crypts nicely in medium sand. Time will tell if root plants do well for me in the play sand/repti sand mixture. My guess is that they will - most of these plants come from areas that have fine, sandy substrates. Thus I disagree with the general conception that plants do better in more specialized "plant" substrates. From my experience it's a lot more about providing the proper light and nutrients. And for heavy root plants, there is nothing quite so effective as root tablets. I found that out when I placed one under a crypt that I have which never seemed to grow more than a few leaves before it melted off back to nothing every few weeks. Placed one broken off piece of a root tab under it and now it hasn't melted since a few months ago and has a good twenty leaves or so. So much for Flourite.
On a final note - the reptile sand is completely inert pure quartz if it's Zoo Med Repti Sand. Here is the email I got in response to inquiring with Zoo Med about that:
Thank you for contacting us. Repti-sand is a natural product with no
additives. It should be fine in use in an aquatic tank.
Please let me know if you have further questions or comments.
Regards,
Rita Zarate
Dir. Customer Service
Zoo Med Laboratories, Inc.
3650 Sacramento Drive
San Luis Obispo, CA 93401
Toll Free 888-496-6633
Direct 805-542-9988
Fax 805-542-9295
www.zoomed.com