A fool would deny how poorly the church has historically treated the LGBT community. This much is essentially self-evident. But that's not the pressing issue here; the issue is whether or not homosexuality is a sin. Suppose it is, like the history of the church has taught; I don't see how discrimination is present if homosexual acts are truly immoral. But I digress.
You're correct in locating the two main texts relevant but I think Romans 1 is the only chapter that really deals with what we modernly speak of as homosexuality. You pose the right question: what is Paul seeing? Is he seeing pure debauchery? Or is referencing monogamous consensual same sex relationships? It's not easy to tell. One way to go about it, as many have done, is simply to side with what the church has historically taught. The other, which seems like what you endorse, is interpreting that text in a new light: in it's proper context as Paul talking about debauchery. I honestly cannot say one way or the other but the Catholics have not changed their stance. While I might disagree with that stance, I can still respect the choice to remain faithful to what they think is true against the changing times.
Have you read The Moral Vision of the New Testament? If not, I would highly recommend it. Hays treats this exact subject with intellectual seriousness but also humility and gentleness.
The classic book on Christian Ethics is Richard Hays's book "The Moral Vision of the New Testament".
The Moral Vision of the New Testament: Community, Cross, New Creation, A Contemporary Introduction to New Testament Ethics https://www.amazon.com/dp/006063796X/ref=cm_sw_r_cp_apa_i_uU5TDbBTFWQSR
https://www.amazon.com/dp/0802866018/ref=cm_sw_r_fm_apa_i_NW5TDbJBZ68XS
My husband recommends these two.
And as far as Christian ethics world view goes.. I urge you to consider the macro effect of democratic policies. Abortion rates go DOWN when democrats are in power because their policies are more women and baby friendly and they promote sex ed and contraceptives. If we look at net harm and net good I think Democratic Party is my personal party of choice to reduce overall abortion harm.