Some one who has entered a relationship with Jesus, as defined by the Bible, would not be flawed, they are said to be made whole.
They may still struggle with "sins of the flesh" but this is where the mystical element of Christianity comes in to play. In God's eyes you are whole.
A person who actively fights his sin would be eligable to serve as a Pastor, yes. So, choosing celibacy over homosexuality would qualify, even if he slipped up now and then. There is a difference between slipping and being intentionally disobediant.
I really don't go to church much. I grew up going, I go at Christmas and Easter but I like to think my congregation would be accepting. People are people though and as imperfect as all people are, some may be hypocritical. The church doctrine would be accepting however as is true Christianity. Some people just have a judgemental thorn you could say.
I believe it was Peter who recommended Christians educate themselves on all religions of the world, not to replace their Christian faith but to know and understand. According to the Bible, this behavior is spiritually healthy, so long as other religions do not become idols.