I was also very apprehensive about the first treatment, but it has actually been easier than I expected. I now look forward to it each week, because I envision it as forward progress.
I've found that creating some light conversation with the person(s) doing the instillations helps me, and it also helps them feel less awkward about what they're doing. After all, there's nothing really comfortable about this procedure for either person, and you may as well make the best of it.
My team doesn't give Lidocaine without my request. ...Something about making the BCG slightly less effective. Whatever. Though I don't like the Lidocaine, I like the catheter even less. I figure that by the time I walk through the hospital and all the way back to my car, I'm sure the BCG and Lidocaine become thoroughly mixed together.
My urologist did not require me to stay for the 2 hours, and also doesn't require me to turn/rotate during the treatment. I was able to go home and relax. I turned on a good movie, and was able to go the entire 2 hours.
I stopped fluid intake 3 1/2 hours before my appointment, and have been doing that for each of the instillations. So far, it's worked well for me and I've been able to "hold it" for 2 hours each time. I totally recommend diverting your thinking with a book, movie, etc. - especially for the last 1/2 hour. Pick a movie that doesn't have flooding, waves, rain or waterfalls in the plot.
Understatement of the year: I'm not a fan of catheter insertion. I've requested Lidocaine prior to the catheter, and it makes it way more tolerable for me.