My favorite depiction of sin, lust (mortal sin) and destruction is in A Portrait of the Artist as a Young Man by James Joyce, which I find to be the most beautiful work on the subject. This is because the protagonist, Stephen, is so sincere in his self-hatred and desire to be better. And because he reminds me of myself, not necessarily with the specific sins he references, but with how he feels.
As he crossed the square, walking homeward, the light laughter of a girl reached his burning ear. The frail gay sound smote his heart more strongly than a trumpetblast, and, not daring to lift his eyes, he turned aside and gazed, as he walked, into the shadow of the tangled shrubs. Shame rose from his smitten heart and flooded his whole being. The image of Emma appeared before him and, under her eyes, the flood of shame rushed forth anew from his heart. If she knew to what his mind had subjected her or how his brutelike lust had torn and trampled upon her innocence! Was that boyish love? Was that chivalry? Was that poetry? The sordid details of his orgies stank under his very nostrils: the sootcoated packet of pictures which he had hidden in the flue of the fireplace and in the presence of whose shameless or bashful wantonness he lay for hours sinning in thought and deed; his monstrous dreams, peopled by apelike creatures and by harlots with gleaming jewel eyes; the foul letters he had written in the joy of guilty confession and carried secretly for days and days only to throw them under cover of night among the grass in the corner of a field or benaeath some hingeless door or in some niche in the hedges where a girl might come upon them as she walked by and read them secretly. Mad! Mad! Was it possible he had done these things? A cold sweat broke out upon his forehead as the foul memories condensed within his brain.
The ache of conscience ceased and he walked onward swiftly through the dark streets. There were so many flagstones on the footpath of the street and so many streets in that city and so many cities in the world. Yet eternity had no end. He was in mortal sin. Even once was a mortal sin. It could happen in an instant. But how so quickly? By seeing or by thinking of seeing. The eyes see the thing, without having wished first to see. Then in an instant it happens. But does that part of the body understand or what? The serpent, the most subtle beast of the field. It must understand when it desires in one instant and then prolongs its own desire instant after instant, sinfully. It feels and understands and desires. What a horrible thing! Who made it to be like that, a bestial part of the body able to understand bestially and desire bestially? Was that then he or an inhuman thing moved by a lower soul than his soul? His soul sickened at the thought of a torpid sneaky life feeding itself out of the tender marrow of his life and fattening upon the slime of lust. O why was that so? O why?
He cowered in the shadow of the thought, abasing himself in the awe of God Who had made all things and all men. Madness. Who could think such a thought? And, cowering in darkness and abject, he prayed mutely to his angel guardian to drive away with his sword the demon that was whispering to his brain.
The idea of surrender had a perilous attraction for his mind now that he felt his soul beset once again by the insistent voices of the flesh which began to murmur to him again during his prayers and meditations. It gave him an intense sense of power to know that he could by a single act of consent, in a moment of thought, undo all that he had done. He seemed to feel a flood slowly advancing towards his naked feet and to be waiting for the first faint timid noiseless wavelet to touch his fevered skin. Then, almost at the instant of that touch, almost at the verge of sinful consent, he found himself standing far away from the flood upon a dry shore, saved by a sudden act of the will or a sudden ejaculation: and seeing the silver line of the flood far away and beginning again its slow advance towards his feet, a new thrill of power and satisfaction shook his soul to know that he had not yielded nor undone all.