Basically aragonite reef sand is preferred, but some like cc
& barebottom also. All have advantages, though I think sand is what you see most often.
The hardware store sand is not ideal (aragonite), it is silica which will not buffer the PH
and it can cause other problems as well.