r/OpenChristian has a fantastic resource sticky at the top of the sub with several books and other resources. Definitely recommend perusing that.
While not specific to LGBT+ issues, John J. Collins' book <em>What Are Biblical Values?</em> has a really balanced and thoughtful approach that I would recommend especially if you're interested in something that is a little more "two-sided" - he really refuses to actually assert a particular answer and is more focused on the process.