I agree with you Lloyd about surgery or dentist, although I have had the dentist knock me out when it is more than a cleaning, which make the whole thing much better.
I have had multiple surgeries and while I do not want to go back, memory is odd and the weeks I spent in the hospital, are actually good memories, partly because off wonderful nurses and a fine doctor.
How I got there is a different story.
Godspeed on your recovery (I have to admit I have a fond opinion of Vicodin; used it to fall asleep, and saved some for nasty sinus headaches.)