No wonder. Regardless of the inspiration, reality with its liberal bias favors the successful rather than the honorable. These concepts are not inherently incompatible, but way more often than not are, and always were.
Yes, the king himself committed adultery and murder. After this, David was rebuked by the prophet Nathan with the word of Jehovah (2 Samuel 12:1-14). You see, God immediately condemned what David did. Then He spoke a judgment on David and on his house (Israel): "Now therefore the sword will not depart from your house forever because you have despised Me and have taken the wife of Uriah the Hittite to be your wife." (v. 10) The sword, that is, war, has not left the nation of Israel. They are constantly fighting for their survival. David was even personally disciplined by his son dying and his wives being treated as he had treated Uriah's wife (vv. 11-14).
After being rebuked, David mourned. At this time, he wrote Psalm 51. In it he repents and confesses his sins to God, saying, "blot out my transgressions", "wash me thoroughly from my iniquity", "from my sin cleanse me", and "purge my sin". Eventually, David's repentance and confession joined God's forgiveness and the result was Solomon, through whom the temple was built and Christ was produced.
Cherry picked or not, every concrete example brought up in this thread (Burr/Hamilton, Cheney, and those I gave) is supporting my point of view. The opposing point of view (which I infer you support from your post) has not brought up a single supporting example, even though it starts at the inferior position (if you claim things were different, the onus is on you to demonstrate the direction, character and rate of change!).
Yet you dismiss those examples as being "outliers" and cherry picks given without diligence. Oh well. I am wrong in trying to arguing with people who care not about the facts. But I have a little time to kill, so it's ok.
I feel sorry for approximately half of the human race, and I sometimes have trouble determining which half that is.