Wasn't there that original series Star Trek episode "Requiem for Methuselah" that had a female android who was invented by an immortal named Flint who had lived many identities such as Leonardo Da Vinci, Brahms, Solomon, Merlin etc? He had invented a mate for himself named Rayna, but she was missing a vital ingredient: to be able to love him back properly.
However, Kirk formed a relationship with her, not knowing that she was an android, and taught her how to love. But when she learnt those feelings, she was attracted to Kirk and not to Flint. However, she dies in the end because she is torn between her romantic feelings for Kirk and her loyalty to Flint, which causes her to overload.
The thing about a robot who would satisfy all your sexual and emotional needs is that they would have to be programmed in such a way as to be subservient to your will and to do your bidding. But they would always be missing something until they become more human. But once they do achieve that humanity, it's likely they'll either turn on you or would fall for someone else, and might be appalled that they were used as sex slaves. So it's always a catch 22 situation.