I Am Getting Set Up For A Couple Procedures From

I am getting set up for a couple procedures from my urologist. one to pump water into my bladder to check things out, then a scope to look around. seen youtube videos about it. looks very painful. has this procedure been made any more comfortable or is what I am seeing the painful truth