It depends entirely on the person. Both yourself, and your partner.
I have basically 0 sex drive by myself, usually. When I take progesterone, it can go up (it competes with estrogen and can raise T a little, but if you are on full HRT it won't make a difference) and some days I'm just horny... everyone has that.
I actually really like that I don't feel the need to do myself off 3-5 times a day anymore. I had a ridiculous sex drive when I was younger. I like not being horny all the time.
That said, when my girlfriend goes for the back of my neck, or massages my breasts... I'm awake.
Now erections are hard to maintain, fluctuate quite a bit from session to session, during session, etc. Generally if I'm not wearing underwear, or inside my partner, I'm not going to be remotely erect for long. Sometimes I can't stay hard enough for penetration. Sometimes I can't finish. For the most part, it works. Oral does virtually nothing for me, but only one person has ever made me come orally more than once, and only one other person ever got me off orally (and that was back before ANY aa drugs, let alone HRT.)
I stopped ejaculating a long time ago, with one or two freak episodes in the last year... as well as one day where I had a few spontaneous erections (ruined my day), but neither are something that really should happen. Eventually you will just produce simple clear fluid only.