Jen, I still have that experience fresh in my mind. The substance the nurse sprayed into the nostril actually helped to ease the pain when the actual scoping was done. Maybe I expected something very painful when I had the first scope, it turned out that it was not so bad and when the doctor said that it sounded all right, I felt relieved and forgot the pain instantly. Then each time, I shed a bit of tears for two seconds and held my hand tight. I kept on telling myself to relax and soon it would be over. I remember having this nose scoping for about 4 to 5 times. You are right you need to learn to get used to it, whether you like it or not (noone likes it for sure). I didn't have any more of this when I was about 3 to 4 months post treatment when my oncologist felt sure that the area was no more of a concern.
Be relaxed, the only advice I can give you now.

Karen.