I know what you mean about being nervous. I was diagnosed with a low-grade noninvasive Ta tumor on January 3. I went to the ER with blood in my urine. Not only blood, but I was passing what looked like dark tissue. The triage nurse wanted to send me home, saying it could just be stones. But, I knew this didn't feel like stones. So I stayed and that's when the tumor was discovered. I'm 28, and my urologist is still amazed that there was a 43 gram tumor in my bladder. It is very important to get that checked out.
I have had the scope done during my surgery, but of course I was asleep. I had to have a stent put through my left uterer (through my back along with a nephrostomy tube) and I have to get that removed, through the cysto in my urologists office. He used a very rigid tube (bigger than a normal cysto scope). I don't want to scare you (especially b/c if you are just getting looked at, your scope will be much smaller and flexible), but he had to stop the procedure b/c of the pain. Mostly my having to contort my body to take in the stiff cysto. I had no pain killers, just a few Valium before. Now, my urologist has decided to borrow from a hospital a more flexible grasp tool and he prescribed me some Versed, a pain killer classified as a "hypnotic," which should put me to sleep. God, I hope so.
The normal regular check up cysto, though, from what I hear is quite painless. I shouldn't say quite painless, b/c nothing passing through there is without pain. I hear the most discomfort is when it passed by the prostate. I hope you let me know how your experience went, b/c I have yet to have a (normal) experience on my own. Good luck with everything, and you are in my thoughts and prayers.