Once I slept on my arm and when I woke up I could NOT move it no matter how hard I tried. It would literally not respond to my neural signals.
But the most pain I had was earlier this summer when my gall bladder failed and I was puking up gall. Cramps were terrible and I too had a 4" needle stuck into my dick. 3 days later when I could get up they pulled it out.... slowly ='(
I still have nightmares.