I hope whatever is wrong with your right eye gets cured. Needing an injection in the eye would require some kind of sedation. I used to inhale nitrous oxide at the dentist to sedate my discomfort and apprehension. You could suggest such a method to you doctor.
Diabetic Retinopathy, what he’s doing is working and they do a lot of numbing (Lidocaine) before the jab. It’s just the thought.
Nitrous and I are old friends. I learned that if you breathe too deeply, too fast, it’ll just about make you pass out. And between the Nitrous and the Novocaine, I stay pretty numb. :)