I use either aluminium oxide or ceramic grit. For deep texture use 60 grit or coarser, for finer stuff, possibly up to 180 grit.
Depending what you have in mind, you might also want to look in to sandblasting film, which can be used as a masking medium. You can also improvise with masking tape, duct tape etc.