no, a relationship requires both. i've dated guys before who were 'good guys' but for whom either i wasn't physically attracted to them, or the sex was horrible, due to incompatibility issues or differing sex drives, etc.
in my experience, a guy can be great on paper, and even treat you really well and be 'right' in many ways, but if you don't get butterflies around him and want to jump his bones, its all gonna burn up in your eventual frustration with the situation. its really the common sense reverse of the opposit scenario- a guy you're crazy-in-lust after, but who treats you like crap and has an aweful personality.
you can't have one without the other- and hope for it to be a full and healthy pairing.