Randy, the biopsy experience for most patients is not a big deal but for some, like yourself, it indeed can be "horrible". We have had a number of threads here concerning patient experiences with biopsies.
FYI, many urologists conduct the biopsy under IV sedation. You still have the after effects of bloody semen and a little discomfort, but you sleep through the biopsy itself so that part is painless. Doing follow up biopsies for men on active surveillance is usually recommended but you might want to consult a urologist who uses IV sedation so that you do not have a repeat of your first experience.
Good luck.
Tudpock (Jim)