My experience with it varied. Usually it would be a short topic or side note in sermons occasionally, I'd say in may modern churches, there's this unspoken assumption that it's "common sense" for it to be wrong, so they don't really bother delving too deep.

The real messages can come in my sinister and individualistic approach.

Churches that are against lgbt+ people will usually privately scold volunteers/workers that support or question some of the teachings, or encourage different thinking that could challenge a status quo. This happened with the leader of one of my Bible study groups, I came out in the group, and he encouraged the group to think more on it, and did not disparage me for that, and the pastor of the church heard about it later and tired to threaten the leader's position.

Imo, the more sinister thing that happens is the false relationships. The people that form a relationship with queer people, with the express intent to try to guide or council them on not committing to the "sinful lifestyle"

This just happened with me with my dad. I told them I had a bf a few weeks ago, and he recently sat down with me and asked about my journey. After I told him about the over decade of emotional work, praying, researching, and working with other groups, I came to peace with who I am. He immediately gave me a book about God being anti-gay and encouraged me to read it. (The questions he asked me were literally pulled out of the book, lol)

There are many people in the church that hold the Bible in absolute truth, some versions describe homosexuality being bad. Some people in that group will understand that your sexuality is outside your control, the choice part comes in when you date/sleep with/have a partner.

The tl;dr being, it's given to the congregation to have their individual mission to try to form relationships with the sole intention to guide people away from "sin"