black sand doesn't make anything "pop" in the sense that the term is usually used.
Diamond Gobies don't actually change coloration due to the use of black sand... they simply appear brighter because of the darker background color. Ditto with corals.
On the other hand, there ARE certain other Gobies that will only show their true coloration if black sand is used.