Basically, the aquarium doesn't "need" substrate... and a bare bottom tank is easiest to keep clean...
The only real benefit that substrate offers is additional surface area for bacteria to colonize... One could also argue it can absorb the shock of a falling rock or other object...
But the main reason people like to use substrate is for the appearance... and in that regard the substrate that you like best is the best...
Just keep in mind the larger the substrate the more particles will fall down into the substrate where it can rot (biodegrade)... and if the substrate is too small (fine sand) then it can get swooshed into the water column where it can damage filters.
The only real benefit that substrate offers is additional surface area for bacteria to colonize... One could also argue it can absorb the shock of a falling rock or other object...
But the main reason people like to use substrate is for the appearance... and in that regard the substrate that you like best is the best...
Just keep in mind the larger the substrate the more particles will fall down into the substrate where it can rot (biodegrade)... and if the substrate is too small (fine sand) then it can get swooshed into the water column where it can damage filters.
