I went through all of Scouts. I worked at a summer camp for 3 summers as well.
Basically what it all comes down to is: Local unit leadership is (usually) great, and ignores the BS (such as the homophobic crap), District is often stupid, Council is really stupid, and National (including the stores) is filled with morons and religious wackos.
When possible, deal with local people. If its a district event, and you just show up and send your son off with his den/pack, none of the leaders should care all that much (including the ones leading activities). The lower on the totem pole someone is, usually the more they care about the kids having a good time and succeeding and less the BS.
Some of the politics of National (and many councils) is disheartening, especially the black lists that are being released, but on the whole local Scouting is great. It gave me an opportunity to learn skills that have been immensely useful in my life and experience that will last a lifetime. Even many of the values resonate with me, the real values found in the oath and law not the BS National spews to keep the Mormons happy. Many councils realize this, and individuals even more. My troop didn't kick out kids they suspected of being gay (never had any confirmed until they were in their 20s and no longer involved, even then they were not spoken poorly of). The council adjacent to my home council even has a non-discrimination clause that includes sexual orientation (which they flagrantly told National to piss off about). And when I worked at camp, the couples times that staff even suspected that a leader was abusing a child (sexually or otherwise) the police and parents were called, and the leader was either arrested or escorted off the premise and banned.
