I think this is a more of a case of a woman that slightly falls below being the "woman of your dreams" because by the very definition, if it was the woman of your dreams, you would have that sexual spark, chemistry or whatever you want to call it....
But then there are people who argue that you can never have the "woman" of your dreams because dreams cannot become reality and that they are only percieved that way because you overlook short comings or the desired aspects.