score:1
It is gradual training. just try to find a partner who observes five precepts. I think it is a good start.
Upvote:1
If what you want is sex (or a sex partner), you might find it frustrating to be married to "a Buddha".
FYI I take this answer to be advice for choosing a partner, based on the suttas -- although that is arguably not tantra mind you.
Upvote:2
With all due respect, many people overestimate their "achievements". Just because a once-returner has remainders of sensual pleasure & anger, doesn't mean that he/she will act on those. It's of course all really speculation because none of this has been mentioned in the suttas, but I believe a sotapanna and even moreso a sakadagami has such profound level of anatta, that enables them to detach from sensual desire and anger quickly.
A Buddha would have no interest in being in a relationship.
Since you also mentioned that you are a misanthrop, I doubt that you achieved higher states because misanthropy is a generalized hatred towards human beings.
With regards to sex I guess no one can give you a definite answer because humans are way too complex, have different wants & preferences in different life periods, and also their personal attitudes (and former experiences) can influence their relationship life & sexual life.
If you seek for a more loving relationship, make sure to look for a person who has somewhat same interests and goals as you do, and ideally both should practise Buddhism (or some other spiritual endeavor).