It’ll depend entirely on the finish required as to how high you go with grit pads.
For diy the easiest system will be Sait Pads or similar.
They’re a carborundum grit disc you either stick or Velcro to a soft backing pad on to a grinder.
The grinder will have to be variable speed.
Around 3000-4000 rpm.
Start at 120 and go up from there, you must work as evenly as you can or you will create grooves and the polish marks will be evident in certain lights.
Look for a supplier that does a random set of grits as a package, that’ll be cheapest way.
Hopefully you have a spare
tile to practice on.
Be aware tho, if your current
tile finish is highly polished, you will not achieve this on site.
You may get close and from above it may appear the same as the rest of your floor, but from an angle it will look cloudy.
But it may well be good enough to live with. It’ll depend entirely on the
tile placement in the room and how the natural daylight hits it.
Water is only used on 600 grit and above, the pad will say wet or dry on it, and you can tell by its feel that it’s waterproop, it’s waxy.