Here are my thoughts:
James 1:14 But each one is tempted when he is drawn away by his own desires and enticed.
Sin has a desire attached to it, if the desire becomes strong enough we sometimes participate in the sin. We all get led astray by these desires at times.
Ecc 7:20 For there is not a just man on earth who does good And does not sin.
Our confessing sin results in forgiveness.
1Jn 1:9 If we confess our sins, He is faithful and just to forgive us our sins and to cleanse us from all unrighteousness.
Where we get into trouble is if we consistently desire our sins while ignoring God. A persistent willful continuance in sin can result in separation from God.
Heb 3:13 but exhort one another daily, while it is called "TODAY," lest any of you be hardened through the deceitfulness of sin.
There are also sins where we should know better, but choose sin, with knowledge, like Solomon.
1Ki 11:9 So the LORD became angry with Solomon, because his heart had turned from the LORD God of Israel, who had appeared to him twice,
But while we seek forgiveness it is available to us, the cross has paid for a lifetime of sins.
Heb 9:27-28 And as it is appointed for men to die once, but after this the judgment, so Christ was offered once to bear the sins of many.