Yeah, I think the thorn in Paul's flesh was his closeted homosexuality. I think he was horrified and repelled by this, knew that the scriptures say it is a sin, so he chose to remain unmarried and just avoid the whole sex issue altogether. As you pointed out, Paul wrote passages like Romans 7:14 etc that talk about his epic struggles with sin.
The other verse you mentioned, Romans 1:24, illustrates that Paul firmly believed that homosexuality is a terrible sin -- but doesn't say he didn't struggle with it. Interesting that just a few chapters later, he writes:
7:14-25 We know that the law is spiritual; but I am unspiritual, sold as a slave to sin. I do not understand what I do. For what I want to do I do not do, but what I hate I do. And if I do what I do not want to do, I agree that the law is good. As it is, it is no longer I myself who do it, but it is sin living in me. I know that nothing good lives in me, that is, in my sinful nature. For I have the desire to do what is good, but I cannot carry it out. For what I do is not the good I want to do; no, the evil I do not want to dothis I keep on doing. Now if I do what I do not want to do, it is no longer I who do it, but it is sin living in me that does it.
So I find this law at work: When I want to do good, evil is right there with me. For in my inner being I delight in God's law; but I see another law at work in the members of my body, waging war against the law of my mind and making me a prisoner of the law of sin at work within my members. What a wretched man I am! Who will rescue me from this body of death? Thanks be to Godthrough Jesus Christ our Lord!
What overwhelming sin was Paul wrestling with, that made him feel evil, and wretched, and that he did things he hated and did not want to do?
It may well be that Romans 1:24 was very much like Swaggart's preaching against sexual sin -- although I think Paul had much more integrity than Swaggart. But methinks Paul doth protest too much.
But I don't see any evidence that Paul had a homosexual relationship; I think he was so horrified by his feelings that he chose to just be celibate. He seems to think that marital sex is something you just do so you don't burn with lust, but it's better to just avoid that distasteful stuff altogether.
1 Cor 7: 1-2 Now concerning the things whereof ye wrote unto me: It is good for a man not to touch a woman. Nevertheless, to avoid fornication, let every man have his own wife, and let every woman have her own husband.
1 Cor. 7: 9-10 But if they cannot contain, let them marry: for it is better to marry than to burn.
1 Cor. 7: 28 But and if thou marry, thou hast not sinned; and if a virgin marry, she hath not sinned. Nevertheless such shall have trouble in the flesh: but I spare you.
1 Tim. 5: 11 But the younger widows refuse: for when they have begun to wax wanton against Christ, they will marry;