Sadly, he is making life difficult for the majority of gay couples in SF who are perfectly satisfied with domestic partnerships. I had several of those couples as neighbors; they didn't "flamboy" and just want wanted to live a quiet life. Leno and the activist fringe supporting him are about political power and punishing those that disagree with them. What is hard to understand is why San Franciscans, a majority of whom is still straight, keep voting this radical back into office.
You gotta wonder why Barney Frank keeps getting reelected by a constituency with so many Catholics. I think in areas dominated by political machines the majority votes by rote or sample ballots pre-marked for them.