In reality the biopsy is not all that bad. Couple of pinches. First two I had in my hometown. Doctor was a jerk. Didn't give me anything. Even nurse remarked "nothing for pain?" He answered that it was not that bad. Who was he kidding? Long story behind this doctor - patient relationship.
Next biopsy was at Urology at Cleveland Clinic. He gave me some meds for pain, calm me down, etc. It was no problem. Left there and drove 2 hours home with wife. Only issue was a few spots of blood in jockey shorts. Staying over for a few days with 10 hour drive ahead is really a good idea.
Wishing you the very best.