Things We Give Up For Companionship

All we want is love, but as Chris Rock says (paraphrasing) the one we end up marrying is second runner up because our first choice married someone else.  Or is that we end up being someones second runner up?  I think the point is we both end up being each others second choice.  Ok, not you TamStyles since you two have been together since you got breasts and he felt you up.  ;-)

Is this really true?  Do we really end up marrying the second runner up?  Was my greatest love to date really the love of my life?  Will there be no other love to compare?  Is that why so many people are still single because we are still looking or waiting for that first great love to return? Oh, better to love and to have lost then to have never loved at all!  What a crock!  Hee Hee.  As much as that hurt...hmmm me thinks I could have done without all the pain, tears and...I did enjoy the lost weight though...but it was fun while it lasted. 

Here's my dilemma:

I have this friend I'll call Bob.  Bob loves me to death and will do absolutely anything for me. And has.  Even listened to me cry about other men.  I know, I know!

The problem is...I'm just not that into him like he is into me.  We have had this conversation over and over for say 5-6 years.  He wants to move here (from the other side of the US) to be with me.  I'm not interested in that type of relationship with him and I don't want to ruin or loose our friendship.  Some people have said I should just marry him because a marriage is more than sex or attraction but I still have this...FANTASY (WOW) that I can be deeply attracted to my mate and be madly in love and have great sex.  Come on!  I'm still not even 40 yet.  I'm not ready to give up on that dream.  Plus I do love him and I wouldn't want to put him in a situation to make him feel not wanted or loved just for the sake of being with me and making my life easy.  Damn my morals!

What do you all think?  As we get older and are looking to get married for the first or second time do we give up things such as true love for companionship?  What should I do with my friend?