What an outstanding question, Yes ~ All of the weeknesses of those God used, where clearly displayed; The adulterous affair of the 1st king of Israel.
You quoted one of his psalms earlier.( none are righteous... etc.)

David was reported by God to be "a man after Gods own heart".
The bipolar actions of Elijah. the compulsions of Peter.

The rediculous things that James and John asked of the Lord.
These last three used by God to write 1 gospel and 3 epistles, of the new testament.

The fact that God put the prositute from Jerico as Davids great grand mother.
yet God chose to make these flawed individuals ~ Jesus's ancestors.

God hides nothing, yet loves and accepts remarkably different and better than I do. I am trying to learn to do the same... very honestly.

I believe that we are all flawed, You have heard - I'm Ok - your Ok - right.
I think it would be better said ~ I'm not Ok - Your not Ok... but thats Ok.

Unfortunately, some religious people are not there. I from my own experience
found myself condeming my self thru my own religious predisposition.

"I'll beat this God" I would actually say to myself...
To look at this honestly ~ I would be cleaning myself up and presenting myself clean to God.

This Is self rightousness by definition. Self rightousness will never stand before God It's like later. I could just hear him say... No you won't!!

He loved me too much to allow me to remain in that state. of religious pride. It's like.... HAY GOD! Um aah I don't need you... I can handle my own righteousness - Thankyou.

This state of religious delusional self rightiousness is the very thing that shrinks would say ~ keep their offices filled.

Hey, buddy I'm sorry I attacked Nietsche, whom you respect.

Please tell me why you are an Atheist, not for any other reason - than genuinely interested.

Thanks Brad