One of the most influential articles to me is Yale scholar Dale Martin’s “Heterosexism and the Interpretation of Romans 1:18-32.”
I know people who have changed from non-affirming to affirming after reading Siker’s paper “How to Decide? Homosexual Christians, the Bible, and Gentile Inclusion.”
For other book-length texts, I recommend Karen Keen’s <em>Scripture, Ethics, and the Possibility of Same-Sex Relationships</em>.
If you’re interested in any specific part of this question or anything specific in the world of queer theology as well, I’m happy to offer more recs! Peace!