"what it does in relation to the relationship with God" - I agree with 100%... but I think the root of this is not what most people assume
"and how it is detested" - I think it's not detested outright because of the act itself, but because of the harm it does (sin in general) to self or...