Zerbie, I know MANY amazing pastors. My pastor, Rev. Ken Martin is awesome. Even the ones who have made mistakes in their pastoral relationships with me in the past are wonderful people, they just had some beliefs and behaviors that didn't match up with them being wonderful people.
I want to strongly encourage to reach out to some of the pastors in your community... let them know where you're at spiritually and what has happened in your past experiences with church. Ask them what their vision is for their church and if you fit in with that vision.
I think this exercise will be tremendous for your healing and it will also most likely be a powerful witness to pastors who may currently have misinformed ideas about sexuality & faith.