Moisture problems? Have your partner pleasure you orally (go down on you; "eat you out"). It works for me. Also, try experimenting with lubricants. Some are just plain lube, like KY Jelly-- others are flavored or provide warm sensations. Try several kids and see what works for you. Another option is Vagifem, a prescription vaginal estrogen suppository. A little extra estrogen in the vaginal and vulval areas can make a BIG difference in the way sex feels.
Pain? Regardless of what they tell you, there IS scar tissue down there now. In some cases, your vagina may have been shortened. In essence, your anatomy is a little different now. You may want to try different positions to find one that works with your new "terrain". Try being on top-- this lets you guide the action and intensity. YOU are in control. If you absolutely cannot find a comfortable position, talk to your doctor.
More tips: Don't rush things. Take your time and learn to RECEIVE plenty of pleasuring. I also had a hard time getting started, but once my sweetie and I hit on the formula one night after lots of experimenting (and pain and tears and dread after so much painful sex)... I had such an orgasm that I had aftershocks for an hour afterward. SOMETHING just hit right. I was on my hands and knees, and my sweetie was short-stroking instead of ramming it home as usual. Perfect combo! I got off like I hadn't done in years. I thought about that all the next day, and guess what? I got horny. We did it again. And I got horny again. My drive came back.
Yes, I'm on HRT (Syntest). Have been for several years now. But I had come to dread painful sex and my libido tanked. When we had awesome sex, it was an aphrodisiac. We found a way for sex to be fun again for BOTH of us.
So, take heart. It IS possible. But it will take some playing around to learn what feels good NOW. Fortunately, PLAY is FUN!