Here is what I have learned from reading:
Sand filters:
Great for mechanical on a tank, and Super low maintenence. You just "backwash" them. So you don't have to get your hands dirty at all. You just flip some valves, and you pump water backwards through the filter and out to drain. This is a double function. You clean your filter at the same time as doing a water change.
However.....It is not good for bio filtration. You'll need to run a sump, or some other form of bio filtration in conjunction with the pool filter. Which begs the question.....Why use a sand filter when you can just build a nice sump that does mech with filter sock(s) and has a wet/dry???
Bead filters:
This seems like the best of both worlds. It's basically a sand filter that runs backwards. The water flows up through the beads instead of down through the sand. It can do both mechanical and bio filtration. I'd get one of the ones that has an air pump agitator for better bio filtration.
Works the same as a sand filter as far as cleaning. You just flip some levers, and it "backwashes" by running water backwards through the filter and out to drain. Again, doubling as a water change and filter cleaning.
The negative.....Bead filters are pretty darn expensive. Again, begging the question, why go with one of these when you can build a nice sump that does it all for a fraction of the price?