The lidocaine is the key. After that, the noise was a little shocking at first (I still say it is similar to the sound of a nail gun slamming into a wall), but the discomfort was minimal.
Here is hoping for a good biopsy result, Charley!!!
p.s. - Don't let the bloody urine and semen scare you....perfectly normal. I ejaculated the night of the biopsy and it was a bloody mess. I was just curious to see just how bloody it was....yikes!!!!