When I read this title it made me think of a great older movie...
"When Harry Met Sally".
It stars Meg Ryan and Billy Crystal. It examines the question: can men and women really just be friends? Meg says they can. Billy says they can't because the 'sex part' always gets in the way... even if the sex is not going on, you're thinking about it, etc.
If you know the movie, in the end they get married. Of course a dramatic happy Hollywood ending. But, when the point comes when Harry does sleep with Sally... ooo, the look on his face! He KNOWS he has just reaaaallly ****** up and trashed the friendship.
I haven't graduated to the honor of being a "biddy" as Clock would say lol. But, I definately classify as an older tainted broad for sure lol. RP... I've unfortunately had one of those "When Harry Met Sally" situations, and honey, it was no Hollywood ending. The story pretty much stopped at the look at regretful dread on Harry's face.
You say YOU are maybe not good enough for him... have you ever thought maybe he knows HE is not good enough for you? Like when Billy sleeps with Meg on her weak emotional moment, he knows he's been a total dog.
I think your friend cares about you in that he does not want to hurt you or the friendship. Like the posts already, if longing for him is hurting you... pull away, but in a graceful way to your friend.
Good Luck.