In tolerant San Francisco, Proposition 8 backer to head Catholic Church