I have RA and something in my foot related to arthritis(can't remember the name of it) and I've had several cortisone shots. I've *always* had to take a sleeping pill if I got the shot for at least a few days. In my experience, the insomnia usually wears off within 3 to 4 days... but I'm sure everyone is different.
I have been lucky that my mom was able to come when I had to have the shots and help with dd. We cosleep and dd would just sleep with her during those few days. Even though I couldn't sleep sometimes, I was super restless and could get more rest with dd not in the bed.
One thing that helped me the last couple of times was doing somewhat of a bedtime routine for myself. Taking the sleeping pill early, then taking a hot bath with some lavender oil, then relaxing with a book. Like I said, my mom was there to help with dd otherwise there is no way I could do any of that
I haven't needed a cortisone shot lately, but I have to go on and off of prednisone for the arthritis. It stinks but it doesn't keep me awake... and if I don't take it I wake up stiff and in a ton of pain