Hey Paul,
Welcome to the forum. It takes courage to talk about this stuff and that is a big step.
I do not have a simple answer for you, but I know a lot of people here have posted about drugs and alcohol affecting their sex drive, as well as the ability to enjoy things that non-users find pleasure in. But everyone is different and recovers in a different way.
There is a men's group in this forum, and there happens to be a thread titled "sex drive" at the top. You may be able to get some good feedback there. All the best.