Psyche, you have written that you always get what you want and gave examples to prove it. So I think we can assume that you operate this way - whether consciously or not - all the time.
Obviously, you just simply wanted to move on and do different stuff. Psyche, there isn't anything wrong with that. The problems only come in when 1) you involve and hurt other people by pretending things that are not true; 2) you take that pretense to an unseemly level by avowing interest and participation in the kind of work we do which is supposed to deal with that sort of thing, while actually doing everything that is contrary to that work.
Had you sat down with me one day and said: "I don't think this relationship is right, and I don't think I should be living here and trying to do something that really doesn't interest me that much... here's what I want to do"... I would have been perfectly happy to organize whatever support was necessary to assist such a transition. Everyone else in the house would have done so as well. Oh, sure, there might have been some hurt, some unpleasant situations for a period; but you know perfectly well that we deal with that sort of thing matter-of-factly and decently when faced with it.
Was the thought of just admitting you were wrong, that you declared yourself in one direction and found out it wasn't what you wanted so terrible? Was the thought of "losing face" what got in the way? Of being seen as possibly "imperfect" because you changed your mind?
Because, in the end, that IS what this is all about: you just simply changed your mind and went into an elaborate manipulation/charade to mask that fact.
Psyche, you don't have to live here and be in a relationship with Scott to be valued and okay. You never did. Just being honest and direct and stating what you wanted and/or needed would have been so much easier in the long run even if there was some awkwardness. It would have been a damn sight better than all this conniption, drama and carrying-on, and a lot less miserable for all involved.
Do you see that?
And still, with all the energy everyone has put into this, you still haven't been able to just say simply and cleanly: I changed my mind. Bringing up the incessant longing of the "eros theme" as an excuse is just the icing on the cake. Don't you get it? You are entitled to change your mind as much as you want to! Changing your mind, and/or admitting you made a mistake IS PART OF BEING NORMAL. With additional data, everything can change. You had the additional data about living here, being in a relationship with Scott, and that changed your view. THAT IS OKAY. Stop the BS! Stop lying to us, and most of all, stop lying to yourself: it rots the neurons.
Repeat after me: "I thought I wanted one thing but after I had it for awhile, I didn't want it anymore and I wanted something different. Yes, that probably makes me a fickle bitch in terms of romance, but so be it. Next guy I get involved with, I'll warn him in advance that I do not know anything for sure and we ought not to get serious. And the minute I don't want to be there anymore, I won't play head games with the guy anymore, I'll just be up-front about it: 'It was fun while it lasted, but time to move on.'" At least that is honest and clean even if it is not very nice.
Okay, so you aren't a very nice person because you don't really think about others at all. So what? Be honest about it. That at least gives you a virtue.
It might mean that you do things for others for reasons other than pure service, maybe a combination of liking research (pleasure for the self) combined with liking to be praised. Okay, be honest about it.
You see what I'm trying to say here? You need, above all things, to know yourself as you are. If you don't like that person, then you can work from there. But you can't work at all if you don't know what material you have to start with.