I'm partial to carribsea's special grade. It is small enough for wrasses, but large enough that it doesn't get blown around in a tank that has a lot of flow.
For my new system I went with carbseas Hawaiian black sand because I wanted a contrast against the white stand.