Beauty truly is in the eye of the beholder, and a degree of attraction that is higher then what friendship requires is a must for marriage. I'm sure many here remember the humorous but realistic approach of the husband in the movie The Substitute Wife. He saw no point in giving the widow false hope of marriage when she didn't "give him the tingles."
He knew as a husband he would have a duty ....that he just didn't feel he could provide for her.
My dear husband thinks both of his wives are beautiful, but a guy we all know expressed a very different opinion of my sisterwife....he even used the word repulsive as I recall.
I'd wager a fair bit that the honest opinion of everyone in our big family (and my extended family of like 75 people) would be that my sw's face is at least cute if not beautiful.....and her personality is also attractive. One of my sister in laws at first meeting her said she was totally adorable (and I agree. I can't think of anything about her I don't like.)
All that to say that compatibility between people is probably connected to attraction....or vice versa, attraction is connected to compatibility.
There is probably someone for everyone, but it would be silly to fault anyone for not being attracted to any particular someone.
My hubby feels he could love and marry a woman he didn't immediately see as pretty, if she had a good heart......but he hasn't, ummm, had an opportunity to prove that... yet.
There is a line in an old song I find funny "I was born to reject rejection" because the irony is so obvious. (Send a Little Love My Way by Henry Mancini)
I heard once too that I am that I am, the name that YHWH first gave Moses could be translated I will be what I will be. I look at the tremendous diversity of qualities and personalities in the people and families of the earth, and just believe He made us each the way He wanted to.