I also had the TP biopsy 6 weeks ago. My hospital didn't get the memo about any spray, so first two jabs went in, not bad. The two jabs into the prostrate was a little uncomfortable, but that was all the discomfort I felt. Then straight onto the sampling bit.
Personally I found the probe up the bum the worst, they told me that it was the size of a mans thumb - Hmmm.
The lube coming out afterwards was interesting :)
The worst part was waiting for the results, that took 6 weeks, outsourced path testing.
Had a PSA of 5.3 then 5.4, no symptoms, just decided to get tested as I knew a few mates who had had prostrate cancer.
Results - out of 22 samples, 14 had traces of cancer. Gleason 3+4 = 7, TC2 NO MO, so all contained in the prostrate. Next step meetings with Oncology and the Surgeon to decide on treatment options.