I could never be with someone that I am not highly attracted to, but on the other hand it is not that simple.
Many women who are technically *9 or 10s* bore me to look at, and others that are less "perfect" drive me insane. Also, looks alone are static, as soon as someone opens their mouth they become either much more or less attractive. Stupidity, self-obsession, etc., can ruin the whole thing. For me, the voice alone can ruin it.
I am always amazed at the variety of taste in this area, there is an old saying in the used car business: "There is an ass for every seat."