I went into a coma when I was 4 and actually had to be revived on the way to the hospital due to spinal meningitis. I distinctly remember getting a spinal tap a few days later even to this day 30+ years later.
Shit, those thing hurt.
When I was bring investigated for MS, they performed a lumbar puncture on me twice. The first time a junior doc/med student asked to perform it under supervision so I was like 'yeah knock yourself out sweetheart' Tdidnt know what the fuck it was hahaha - needless to say after her 5th attempt at putting a 3mm needle into my spine I wished I'd protested.
They told me that I'd been through enough so a more experienced doc would be round in a couple of days to try again. I woke up 2 days later at 6am and there was a metal trolley next to my bed with all the shit layed out ready lol - 'nurse, can I please have some morphine, I'm in a lot of pain right now - no worries I'll get some for you' Worked a treat!!!