Is it good for our souls to be in tension with our sin..the and answer is: YES!!! Paul is walking us through that tension. He isn't settling into his sin, he's facing it.
Romans 7:15 For I do not understand my own actions. For I do not do what I want, but I do the very thing I hate.