I had a job last year, asked to fit a glazed screen to a fancy tiled shower area. Why the client didn't get the tiler to do it seems to be simply that the screen arrived too late.
i thought this would be a doodle, and gave up after barely scratching the tile on the first hole.
I looked at the perfect 16mm holes for the pipework and phoned the tiler...he said they did them in the workshop with a massive fixed drill with diamond cutter, which works automatically...put the tile in the machine, center the cutter and go for lunch!
He pointed me at this
https://www.NoLinkingToThis/p/marcrist-pg750x-dry-diamond-tile-drill-bit-7-x/72516
It took a long time drilling 5 screw-holes, but it worked...starting at 45 degrees and "feeding" the bit in. I have never come across such hard tiles!
However, I have used that same bit on softer tiles and it just eases through, with occasional dipping of the bit in a glass of water, and it's still working well.