Some do refer to same-gender attraction as their "weakness," as if it were some kind of spiritual illness, often quoting the words of Moroni about the Lord giving "men weakness that they may be humble" (Ether 12:27). But to refer to same-gender attraction as a "weakness" can be misguided. Our challenges and our temptations are not what should be considered "weak," for it is through challenge and opposition that we are made strong--if we will turn to Christ and to the power and grace He offers through His atoning sacrifice. Our challenges simply reveal unto us our true weaknesses or spiritual illnesses--the doubt and fear of putting our lives completely in the Lord's hands--and the weakness of faith in God that would allow us to submit to whatever challenges or temptations beset us. Christ was tempted, and He had challenges, but He was never weak.Ty Mansfield in In Quiet Desperation
It occurs to me before I get started that I may just be splitting hairs. But, actually, that's what I do sometimes. ;-) I have to take issue with Ty on the weakness issue (and probably with a majority of everyone else too!). I consider it wholly appropriate to refer to SGA as a "weakness" or a "problem". That's exactly how I think of it. However, in my mind, there's no moral culpability with that. So, yes, I agree at least that it isn't a spiritual weakness.
Let me make an analogy to, well, weakness itself. After a stroke, a person may have weakness. There's nothing "wrong" with that person in the moral sense, no reason to discriminate, but it's a real weakness nonetheless. There's something "wrong" with them in the physical sense. One might apply Ty's argument to say, "Our challenges [like muscular weakness] are not what should be considered 'weak,' for it is through challenge and opposition that we are made strong--if we will turn to Christ and to the power and grace He offers through His atoning sacrifice." After some physical therapy, muscular weakness may be made strong, but there's a chance the effects of the stroke will be permanent, through no fault of that person's. It may be that the person is "made strong" by accepting appropriate occupational therapy to learn new ways to accomplish activities of daily living given the permanent residual weakness. So one can be strong in one's weakness. But it's still a weakness.
I can understand the sense of celebration associated with Coming Out Day considering the importance of achieving conceptual maturity by accepting oneself as gay and not being ashamed. But, for me, accepting myself as gay (or, more specifically, as same-gender attracted) without shame achieves that same celebration-worthy insight while I still believe there's something "wrong" with it. Being attracted to men isn't wrong in the moral sense, but it's definitely wrong in the reproductive sense, an important part of who I am eternally. It's a weakness--one that may or may not be changed in this life--but, as Ty apparently doesn't care to hear, it's a weakness that I believe Moroni's words very much apply to, and that one way or another can be made strong.