I had a lumbar puncture a couple of years ago and had no problem with it, pain wise at all. After the procedure you should lay down in the office for a while, dont let them rush you, and then lay down as much as possible the next few days to avoid a headache. Also make sure you remain hydrated. My neck was only a little sore, i never got the headache. It wasnt bad all in all and i wouldnt hesitate to have another one if i needed it.