I would echo the comments - mine was easy and pain free.
I had a long wait on the day - I was on the afternoon operating list and the number waiting in the room for a wide variety of operations got fewer and fewer as they were slowly called down. Then several operations got cancelled as there wasn't time to complete them, and I suspected it wasn't going to happen. Finally I was the last person left, and taken down to the op.
Walked in to the operating theatre, laid on the table and chatted to the anesthetist whilst I was hooked up to ECG and blood pressure monitor and cannular inserted into my hand, and had some sort of pre-med which made me a bit light headed but still chatting. Also chatted to one of the surgeons (there were two). Anesthetist apologised that the anesthetic would heart and I recall saying it didn't, and then I woke up in recovery.
First thing, they offered me a cup of water and a chicken sandwich. I'm not sure if I felt hungry, but I hadn't eaten for about 13 hours at this point, so I took it. I had trouble chewing and swallowing it which it took me a moment to work out. I had no saliva - I could eat it only providing I swilled each mouthful down with water. That resolved itself within an hour, but it wasn't a side effect I had ever heard of. I was drinking loads of water, partly because I told I must, and partly because I thought I must be really dehydrated (I wasn't).
I was told I would have a catheter, and it would be removed the next day. I carefully peered at the little fellow, and, no catheter. I asked about that when I saw the surgeon the next day, not that I was complaining, and he said they decided I didn't need one.
I had elected to stay overnight beforehand, because it turned out to be a bad day to arrange for someone to be with me overnight after the general anesthetic. So after a hour or so on recovery, I was wheeled to the ward. The nurses had obviously been told I would be in pain and needing painkillers, and they kept coming in and offering, but I had no pain whatsoever, so I declined. By this time it was midnight, and I was as alert and wide awake as ever, and would be totally unable to sleep so I didn't even bother to try. Don't know if that was the after-effect of the general anesthetic, but I walked around and talked with my brother on the phone for an hour at about 1am - he was driving home from a late event and was also pleased to talk with someone at that time. The nurses wanted me to pee into bottles so they could monitor how much and if excessive blood. First time, flow rate was very slow and there was blood staining in the first few CC's, but flow rate improved over successive pees, and the blood was too little to see in the bottles. I had been put on Tamsulosin 3 days before the op, to continue for 2 weeks afterwards, to help urinary flow and make sure any clots were flushed out, but I never saw any clots in the urine. I was actually quite pleased I elected to stay in overnight, as they were monitoring me every 2 hours, and I did eventually get some sleep.
The big plaster was sticky around the edge and was covering the perineum and arse, and the sticky had also caught the scrotum which was a bit uncomfortable. However, it quickly fell off the scrotum and perineum, but remained firmly stuck on the arse cheeks. It had some dried blood in it, but there was no bleeding after I came around from the op - that was all from beforehand. I had taken a hand mirror in with me, and checked around perineum and arse, and there was no sign of any injury or marks or scabs or swelling left by the biopsy needles whatsoever. Just a little red bruising. I had trimmed the hair on perineum and scrotum as short as possible with a beard trimmer beforehand, but I didn't trim my arse cheeks, and this plaster was stuck very firmly to the hairs on my arse! It took a long time to gradually ease it off, and left me with a slightly rectangular patterned waxed arse cheeks. It also left a lot of sticky behind on my arse cheeks which meant they stuck to my underpants.
At 10am next morning, I was checked out, and went home by bus. It was slightly uncomfortable sitting on the bus seat, particularly when the bus was stationary and the idling engine had the whole bus vibrating, so I tended to tilt slightly onto one arse cheek or the other, to keep the perineum off the seat.
It was 2 days before I could do a number 2. I thought I was constipated but I wasn't - it was probably due to not eating for a day and I think my bowels well emptied themselves before the op in anticipation, so there was simply nothing to feed through. I thought it would be painful, but it wasn't at all. Wiping afterwards was though!
I tried and erection 2 days afterwards, and it was fine and not in any way painful or uncomfortable, and not reduced in length. The consultant had said no need to wait at all, but I figured I'd had loads of needles pushed though the erectile base of the penis in the perineum - I'll not try pressurising it immediately afterwards. There was very little semen (possibly due to the Tamsulosin which causes retrograde ejaculation) and no blood first time, although there was blood on subsequent times, but much less than for my previous trans rectal biospy. I only ever saw blood in the first few cc's when peeing, and that only lasted for 3 days.
In the next days, the bruising came through much more and the perineum, anus, and scrotum went dark brown. At least the dark brown indicated old blood, not new bleeding - it was just moving around inside. It wasn't painful, but it did itch a lot in the scrotum which was noticeably bigger, and I don't think it was just due to trimmed hairs. That took a couple of weeks to go away.
4 days afterwards I was back on my exercise bike, and 8 days afterwards on the road bike (could have been sooner but weather was bad).
Anyway, based on my experience, I would have no fears if it had to be done again (unlikely in my case, as it found cancer in 12 out of 33 cores).