Can any good come out of falling to temptation?

After all, Romans 8:28 says:  "...in all things God works for the good of those who love him, who have been called according to his purpose."

King David failed to withstand temptation - committing adultery with Bathsheba, then murdering her husband to avoid a scandal when it became obvious she was bearing an illegitimate child - David's child.  Yet here is the curious fact: in spite of this enormous failure, God later blessed David and Bathsheba with more children including the wisest son a man could ever have.

Doesn't it look wrong that God would bless a union like this?  One borne of sin upon sin?

Apparently God really does forgive people - more completely than we can even imagine.

On a different note, failure with temptation is a great antidote against self-righteousness.  There's nothing like a significant moral failure to pop the bubble that formed in our heads - that we're quality Christians with big spiritual muscles.  All our effort, high morals and strong will power go out the window.  And then when God continues to love and cherish us as we lick the wound of our failure, we become the most surprised sinners; God shows us what grace really means.

The best outcome from falling to temptation is being picked up again by our gracious God.   Our hearts get softer when we really understand that we don't deserve His love.