Can sex overrule feelings of disgust?

I believe sex is suppose to be sacred between two people who LOVE each other, unfortunately today everybody just sex's anybody or anything for a NUT! Just because I believe the above doesn't mean I have followed my own beliefs and I have been thinking about why is it someone you don't want can make you feel so good sexually.
Everyone that knows me, knows i'm very open when it comes to sex. Sex can be good but have you ever felt guilty when you organism? Has the person that made you cum someone you really weren't into but they made your body feel awesome?
It has happened to me.
I continually went back for that person to make my body feel that way, but felt disgusted afterwards (like yuck, wth was I thinking) all the time. Ugh then I have gotten that person I don't want to be in a relationship with open off of me.
Well yes, shit happens.
But what makes us as human beings not resist sexual temptation to those we aren't attracted to?

A new study suggests that feelings of sexual arousal may serve to override our disgust impulses. The results suggest that sexual arousal may at least partly diminish feelings of disgust, thereby allowing us to do things during sex that we might find unappealing in other contexts.
In another study it was revealed that just because someone isn't attracted to their partner, it doesn't mean that their body physically shuts down. You may not think your partner is hot, but if they touch you in the right way, you’re probably going to respond.

I can definitely understand this, a touch, a smell and or a look can make someone feel some sort of sexual feeling. I have gotten open off a person that smelled good and brush by me. I have gotten aroused by a touch by someone I don't even know. I have gotten aroused if I sleep a certain way nd I know I am not the only one,  but why? Why does it seem that are genitals are in charge of the body at times?

"Sexual desire is an extraordinarily complicated part of life and there is an enormous range of difference,'' said Harold Lief, an emeritus professor of psychiatry at the University of Pennsylvania 

If our brains are so smart why do they let us attach to people who might not be so great for us? Catherine Salmon, an associate professor of psychology at the University of Redlands, says the answer might have something to do with oxytocin, that very same chemical that creates those feelings of warmth and security.

“Oxytocin is not only released during birth and breastfeeding but also during orgasm,as a result, you feel more attached to the guy who you shared that orgasm with, which is great if he's a good mate choice," otherwise, it will suck for you as it sucks for me. 

She also stated "he may be a good lover but poor mate material, and yet you'll be attached to him in the bed and perhaps stick with him longer than you should.”

With that being said the only thing I do is make sure I take control of the lady downstairs, it is harder then it sounds but I guess finding things you love to distract you sexually is the best advice to give oneself