I wouldn't say the shot is comfortable, but it's not painful either.
I had a shot in my shoulder for bursitis when I had combination of that and rotator cuff problems. It didn't by any means solve the problem, but it did help. I still had to do physical therapy and anti-inflammatories for...