This subject feels worn out but okay, (shots versus no shots)
read the online publication, The Burton Report and then only you can make the decision.
Is your neck problem as result of an injury, disc herniation, DDD, bone spur, nerve involvement?
Have you got numbness in your arm? hand? fingers? Pain in those areas?
Skip the shot, and ask a Neurologist for an EMG. This will further diagnose your problem.
No on is going to say that the shots don't hurt. They do. If you are going to do it anyway, make sure that they do it with a flourescope and hit the right spot. As for what is in them, ask the doc, before he even starts, to give you in package insert. If it says cortisone, then I, personally, would back off.
What does your MRI state? Have you had one? Has he tried every other conservative measure?
light narcotic meds
The shot should come AFTER all of this, if at all.
just my take on things. good luck