I can't answer whether it would be worth it to move, but I can say that it has been well worth it to me to be in a welcoming church. My little Episcopal church has been a great blessing to me. I live in a town with 377 people, and I am a long way from an urban area. Even rural America can be warm and welcoming.
I would disagree with one point you made. I don't think one has to disregard any Scripture to be comfortably gay and Christian. I solidly believe that the Bible is God's Word. I am not a literalist, but I am fairly conservative.
I don't see anyplace in the Bible that leads one to believe that God is anti-gay. I see nothing but affirmation in the Scriptures for love shown to God and to others. I believe God is very pleased when two people pledge themselves to each other to love and support.
I feel that the same rules that apply to heterosexual relationships and homosexual relationships. Selflessness and love are the key.
God's blessings on your journey.
Tu Amigo, Pablo
For I am convinced that neither life nor death...neither the present nor the future nor anything in all creation will be able to separate us from the love of God that is in Christ Jesus our Lord. Romans 8:38-39