I just spent some time watching an "exit interview" with a CES instructor and his wife who recently resigned from the LDS Church. I highly recommend it. It's a great window into the conflicts that many orthodox members of the Church experience, especially with respect to the Church's rejection of gay people. I found it interesting that the couple's disaffection began with cognitive dissonance about a friendship they formed with a gay man and his partner.
You can check it out here. If you are a believing, participating member of the Church you might find this interview useful in better understanding what people who leave go through. If you are an unorthodox or secular Mormon, it's required viewing. :- )