Yikes, that sounds really awful. Sorry you had to go through that. :(
I would consider having it done under a fluoroscope in the future. It's more time-consuming and you may have to set up a separate appointment (might be more expensive too, not sure), but it's worth it. When they can see the needle and tell what they're doing, the chances of them having to pull it out and try again are so small. No second attempts, no painful fiddling around. Just goes straight in. Of course there's still a risk of them hitting nerve. The radiologist doing mine managed to poke my sciatic nerve a bit, which created some very uncomfortable spasms, but I'm glad he didn't have to poke and prod around in there, especially since it was my first LP. I was already panicking pretty badly. So yeah, hope you have better luck in the future. LP's are no fun, but yay for being brave and sticking through it.