Visually it looks pretty stunning...the black is deep black and those little reflective specs really leap out when you have some good light on it. Greens from plants, as well as any other colors in your tank (I had Red Cherry Shrimp in my tank with it) show up great because of the contrast with the deep black sand.
On the negative side, it is inert so if you are planning on using it in a planted tank (especially with plants that are heavy root feeders), you'll need to put some sort of root fertilizer tabs in there for your plants.