"Abraham deceived Abimelech about his relationship with Sarah. Isaac deceived Esau and stole both his birthright and his blessing (but maybe that’s okay because he is a patriarch and not a prophet, strictly speaking). Moses took glory unto himself at the waters of Meribah and lost his ticket to the promised land as a result. He was also guilty of manslaughter and covered up his crime. Jonah ignored the Lord’s call, then later whined and complained because God didn’t burn Nineveh to the ground as He had threatened. It doesn’t get a lot better in the New Testament. Paul rebuked Peter sharply for what he called cowardice and hypocrisy in his refusal to embrace the gentiles as equals. Then Paul got into a sharp argument with fellow apostle Barnabas, and they parted company.
"So where on earth do we get the notion that modern-day prophets are infallible specimens of virtue and perfection? Joseph said emphatically, “I don’t want you to think I am very righteous, for I am not very righteous.”. To remove any possibility of doubts, he canonized those scriptures in which he is rebuked for his inconstancy and weakness. Most telling of all is section 124:1, in which this pervasive pattern is acknowledged and explained: “for unto this end have I raised you up, that I might show forth my wisdom through the weak things of the earth” (D&C 124:1; emphasis added).
"Air-brushing our prophets, past or present, is a wrenching of the scriptural record and a form of idolatry. God specifically said he called weak vessels so that we wouldn’t place our faith in their strength or power, but in God’s. Most crippling, however, are the false expectations this paradigm sets up: When Pres. Woodruff said the Lord would never suffer his servants to lead the people astray, we can only reasonably interpret that statement to mean that the prophets will not teach us any soul-destroying doctrine—not that they will never err. President Kimball himself condemned Brigham Young’s Adam-God teachings as heresy; and as an apostle he referred as early as 1963 to the priesthood ban as a “possible error” for which he asked forgiveness. The mantle represents priesthood keys, not a level of holiness or infallibility. God would not have enjoined us to hear what prophets, seers, and revelators have to say “in all patience and faith” if their words were always sage and inspired (D&C 21:5)."