I would agree that transitioning for "sex" isn't really a good idea; however, sex is part of being human. The thing about your sex drive is that it most likely has changed. It will have to be something you'll have to rediscover. A woman's sex drive is different than a man's.
I'll warn you that if sex is your main motivation, even if you discover the feminine sex drive, it won't be the same as you had before pre-hormones. It will feel different not only physically but also emotionally and mentally. When you masturbate, a rush of testosterone can fill your body -- and once your body is used to estrogen it can (in some people) produce a weird feeling. The longer you're on them, the more people notice it.
Also, once you have SRS (if you go that route), the feelings are again different. Physically, a vagina doesn't feel the same as before or feel like really anything before. Yes, you can orgasm, but it's different than before and way different than a mans orgasim. Of course, your vagina feels different and nothing like before, as well. Emotionally and mentally, there are changes as well.
For me, SRS was a good experience for me sexually, as well as in other areas of my life. Previous to SRS when I was on HRT I found more and more that sex was difficult physically, emotionally, and mentally. Pre-HRT/Transition, I think sex was easier in some aspects, but also not fulfilling in others 'cause I knew I had the wrong parts. I found it easier pre-HRT to just use my imagination while having sex to please my partner and for myself to get by and hopefully enjoy the experience. When I was on HRT, over a length of time, I found it harder and harder to just use my imagination and go with the flow. It affected my relationships pretty badly as I didn't like the feeling of it all.
It took time, but I found my womanly sex drive as I went through transition; it was different, but I found it more emotionally and mentally fulfilling. After SRS, the physical fulfillment came into place. It can be a wonderful thing.
I think sometimes it can be taboo to talk about sex when it comes to transition. Of course, sex alone isn't a great motivator for transition 'cause that bridge erodes pretty quickly with HRT and the changes of transition. You stand before the crossroad where you realize that old sex drive and the way it felt won't be back (unless you were to stop HRT, etc), and then you embrace (and find) your female sex drive. It's not an easy task.
This is where your other motivations come into play -- and this is where you find the inner strength to go on and be the woman you are; or stop, and be the man you are. Sex can't carry you through. By only being yourself, and being honest with yourself, can you carry on.
Good luck,
--Natalie