Prostate biopsy - what's your experience?

I've had the all tests/scan etc but now considering the biopsy. Really can't see me allowing someone to inject me in that location. What is your experience?