I understand what you're saying and I totally agree this is what he's thinking.
I think he truly meant what he said at that time. But I also think that these things have little value to him on the whole scheme of things in his life.
But it doesn't change the fact that I felt used. He had to use my body to validate that he has no feelings for me. How does that make me feel? I am the cause of my own inadequacy to fulfill his needs and it had to be proven by "me".
I don't want to go into explicit details....but what he did that night showed he had no respect for women. I knew he had gotten his answer halfway and he could have stopped. But he went on, did things (actions censored) purely for his own pleasure.
It's funny -- this *just* happened to me, too, and I had a total melt-down over a 24-hour period, to the point that I was driven to ask for help (huge, for me), slept almost all day yesterday, am back to work today still tired and a little fragile, and still covered in hives. I went ape-shit. "He had to use my body to validate that he has no feelings for me." And then he wants to be friends.
Well. But he did. And he does.
You just have to get over it, I'm afraid.

If it means that much to you, don't let anybody have it till you've heard and seen what you need to hear and see beforehand.
For me, the test of whether I wanted to be friends with this person is how did he handle it when he saw the tip of the iceberg of my meltdown and when I let him understand that I was upset. My person came through and was a man for me and I give him props for it.
There were misunderstandings, in my case. I did hear what I wanted to hear and ignore what I didn't want to hear; he did say a couple of conflicting things to me so it's not surprising I had it wrong. And you know what? The sex wasn't great for me either. I just saw potential and it had its moments, fleeting though they were, I caught clear glimpses and flashes of what I want, and that made me off the hook crazy for more. But ... he's decided to go with someone else, and there's nothing I can do about that.
Realize that you're jonesing for the thing you thought you saw. You didn't actually see it. You just thought you might eventually see it.
Also consider that this guy is perhaps a harbinger. He opened you up and now your senses are raw and attuned. So take that and use it.
He may turn out to be a friend after all. He may not. Either way, it's ok. You don't have to feel raped about it. You have a choice in how you frame this. Rise to it and frame it well for yourself and use it to propel you into where you want to be. And play a little harder. You're playing awfully soft, do you understand what I mean? SMACK the ball, RUN, get your speed up, say yes, say no. Don't sit around typing and sit around listening. Don't put time in and then resent it, and don't have sex until you know you're in good hands, or unless it's purely recreational for you both.
Ok, back up on the horse. You're ok. You really are. Go get what you want now.