I was really worried, as I am a wimp when it comes to pain. Got into the room with the xray/floroscope and they have you lay down with a pillow under your stomach.
He didn't use any sedative or IV pain killer, just local shots of Lidocaine I think. The shots of the numbing agent kind of hurt a little. Like any other shot, just not as painful. He used quite a bit, and probably injected a little bit in 5-6 different locations.
He gave me two different steroid shots in two different locations, due to the fact that I have two disc herniations, L4-L5 and L5-S1. I didn't really feel him put the needle in at all, no pain whatsoever. When he injected the steroids, it felt like pressure, exactly like he was pushing with his hand on my back. Honestly that is what I thought he was doing at first. Didn't hurt at all.
It was over, from the very start to the finish in maybe 3 minutes. It was over so quick I couldn't believe it. Much much easier than I thought it would be. I go back next month for another and one more a month after that.
After the injection, I didn't notice any more or less pain. Today, it is pretty much the same as it always is. I expect it will take several days to see any improvement if it works.
The worst part of the whole experience was paying the $700 honestly. It may be different for other people, or it may be different next time I go in, but for me, this time it was pretty easy. Hope this helps some.