I've had two MRI-guided TRUS biopsies - age 66 for the first, 67 for the second. Both times, the urologist indicated that I would be under "twilight sedation," which I understood to mean "conscious, but out-of-it." I was given Propofol, and I was unconscious through both procedures. Woke up feeling fine and walked out of the hospital under my own power. I was on my way home a little over an hour after they took me to the OR. They required me to have a driver (my wife), but I could have driven myself, no problem.
A little blood in my stool the first time I had a BM. Blood in my urine for a few days, but after the first time I peed, it was just a little pink for a couple of seconds and then went clear. Blood in my semen until I had ejaculated maybe 6 or 8 times. They had told me to expect blood in my semen, but I was thinking a little pink, like my urine - but the first couple of times, it was the "murder semen" @scottbeammeup mentions. A little unnerving!
No pain for me. Just a little "pressure" - felt like I needed to have a bowel movement when I didn't. That lasted two or three days.
No antibiotics before or after, but they may have given me some intravenously during the procedure.
Thank you for your helpful feedback!