The key to a proper;y function s under gravel filter, whether the traditional air powered or the pump powered revererse confidguration, is the size of the aggregate.
"Do undergravel filters really work?
It increases the amount of surface area available to the nitrifying bacteria, and it creates a constant flow of aquarium water over the colonized area. The most popular kind of biological filter is the undergravel filter. It is relatively inexpensive, reliable, and
very effective."
The reason sand will not work is it will not permit adequate flow through a 3 inch bed. The sand filter many of us know is the one on swimmng pools. But the sand is in side a closed container and the pressure of the water flowing rhough it tumbles the sand so the grains are not all stuck together. There it traps debris rather than hosting bacteria. But if it was needed it could be seeded and used for that as well. All you need is an ammonia source and no more chlorine.
The ideal gravel of and under gravel is medium sized. Too small and it gets more sand-like and too large and the flow rate becomes to fast and the available surface area is reduced.
My first tank had an UGF but after a few months I converted it to a RUGF using a reversible flow powerhead. When I would remove the prefilter to clean it I usually lifted the powerhead of the uplift tube. This often dislodged it from the hole in the filter plate. Reverse fl;ow means there can be gunk building up under the plate that one will have to siphon out eventually. My tank was on an angle iron stand so I could look up through the bottom glass.
I decided to do this after several months and tI was surprised to see a few swordtails and panda cory fry under the plate and alive. This ended my time using under gravels. I had to empty the tank of everything to free the fish. I was only willing to do that once.
However, an undergravel filter is simply the best bio-media one can have. The next best is thing is a Hamburg Mattenfilter. However, a planted substrate is still the best filter an aquarium could have. However, not all tanks can be planted and not all fish keepers want to deal with live plants.