I honestly think your lfs is basing that off of their personal opinion. Alot of people don't like the look of black sand. I have even had lfs's try and talk me out of black because they only carry white. I have heard that it will cause tank crashes, it gets dirty and ugly, and it's contaminated, in addition to people just not liking the look personally. I first saw black sand on a forum in 2004 and had to have it. I have been using it since. Now it's pretty common in lfs's and is even being sold in "live" form.
I have heard many talk about it looking dirty after a while. Well, in my experience, if you don't have adequate flow and don't do proper maintenence, any substrate (or lack of, BB) will end up "dirty". I have sand that has been in a system for 3 years and looks as good today as the day I put it in. I wouldn't say I notice any difference between the grains on black and normal sand, although it is not a powder sand.
As most sand that is labeled "live" is bagged with a little water and stored on a shelf for God only knows how long, I question how "live", these live sands are. I always seed with sand from an established sand bed. This is a good practice to do routinely anyhow as it adds diversity to your tank and keeps your sand "live".