Ambrose put forth the idea that Lewis may have suffered from Manic Depression. Thomas Jefferson described a melancholy disorder in the family. Lewis's suicide shortly after the return to civilization apparently did not surprise the man much who knew him best--William Clark. As a manic, if indeed he was, he could have shined at organization, but really come unhinged if not kept busy. And like you said, he does come through as lacking a governor.