I found that when on HT, I didn't get so much as a salacious thought, let alone an erection or orgasm.
Once off HT, 'normal service' resumes within a few months.
After RT, the ejaculate is thin, clear and sticky, and there's not much of it, no need to worry about who gets the wet patch of the bed after sex!
A couple of months ago I started ejaculating old blood, it was the colour of Ronseal wood stain, quite similar to the ejaculate following the TRUS biopsy.
I was concerned and contacted my team, I was told it was nothing to worry about, just blood sloughing from the prostate, or what's left of it, into the seminal vessels, and after about a month-6 weeks everything has returned back to clear again.