Feelings and Desires

Is it possible to have a relationship that has the all-consuming passion and lust and desire for sex like in say romance novels, but also the closeness and the soul-mate feeling? I’ve heard some people say it is possible to have both, but that most people dont have both and are happy with what they do have. I have had one relationship with most of both worlds, but I still felt there must be more, something I was missing out on. Another relationship was just lust, but we werent compatible emotionally, third one is brilliant in the 2nd respect but doesnt quite live up to the 1st. How important should each be to each other? I feel my heart pulls me in the direction of emotional stability, but there is this wild sexual side that I have never been able to experience fully, I don’t know if I’d even enjoy if I had it. Maybe my expectations are too high? Maybe I’m searching for something that isnt out there? Should I be searching for something else or be happy with the relationship I do have? I have this unsettled feeling with most things in life, the what if, is this normal? Do other people have these sorts of feelings? Hope I’m making some sense. If someone could give me a little help I’d be grateful.