I am no Spartan nor into pain in any weird way, but I have had teeth drilled for cavities and surgery performed on my hands while "mostly conscious" & could give feed back to the surgeon. Sponge Bob, as he was known, did tell me not to tell jokes as that was distracting the surgeon (him). Probably like telling dentist jokes before the exam.
But, mostly concious does mean planned, intended, and coordinated with the surgeon which is quite different that the expectation (presumably) by all that I would be totally under & completely unaware ... which I have had also. There were the nurses that came by during recovery the day after that introduced themselves to me. Lets just say that they are not all fat and nasty.
I, for one, do not consider surgery as a necessary evil. In a way I would opt for it versus "drugs" for an alternative & often 1st treatment. As usual there is an optimum and every case is different.
To the point, waking during a major surgery & not being able to move is not really waking, I think is not completely a bad thing. Maybe the squeamish would not be crazy about scraping of bone via the vibration, but other than that, there is no other sensation as pain other than there is some poking around a "there".