In my experience, which is way limited in saltwater but relatively good in freshwater, sand is a big pain in the a@#$%. However, saltwater sand is the complete opposite of freshwater sand....
First, if you get live sand, the kind that is sort of wet when you buy it, it doesnt need cleaning or any of that (it would defeat the 'live' part of the live sand). I debated long and hard about it myself and decided live sand is best because it will serve a bigger purpose than coral in that more bacteria can be held in in since there is more surface area (I didnt believe it either, but apparently more granuals equals more surface area)
So, in my new saltwater tank, i have 80 pounds of live sand. I promise you that these pictures are taken about 14 hours apart, but this is what the tank looked like right after I dumped in the sand (the tank was already filled up with all pumps and mechanicals running)
I was scared to death when I saw this because I figured since I didnt really have the traditional filter like a freshwater tank, it would take a month for the sand to settle out, but I went to sleep and woke up to this:
I know that you might think I could have taken these pictures a week apart, but I swear I took them 14 hours or so apart. This sand settled out SOOOOO fast that I was almost convinced enough to change my freshwater tank back to sand!
So, I know this didnt really help prove that sand is the best option, and it really is a matter of opinions, but I wanted to let you know that sand isnt as scarry as it may seem; at least as far as saltwater live sand goes.