Hi Bill.  MD—clinical practice + research.
I think it's important not to confuse ideology with science.  For an entertaining and ‘left-friendly’ view of how the APA was pressured into ‘normalising’ homosexuality, see https://www.thisamericanlife.org/radio-archives/episode/204/81-words .  
There’s precious little that’s scientific about psychiatry; most meds that are any good were discovered by accident.  Psychiatry today is where medicine was in about 1820.
Also, don’t imagine that professional bodies speak for practitioners as a whole; not by a long shot.  They’re pretty irrelevant to our lives.  When I belonged to the AMA, it was simply because at the time you had to if you wanted to get the NEJM. 
There are clearly certain professions where male homosexuals are much more common, and one of those is the clergy (and not just in churches that require celibacy!).  But because of the ideological climate, scientifically sound research in any of these areas is well-nigh impossible.