It's all in the heart
"I write a juicy sex scene and that voice screams “Now what?”
I'm not quite certain what your Genre is, but I'll presume it is romance. And it sounds like your situation is that the reality of life and your vision of romance aren't on the same page.
And so, you doubt your faith in "Romance", or feel hypocritical for writing it, when the ending never seems "real" to me?
I wouldn't call that "writer's block", but "heart-trouble", in the sense of your emotional heart, better phrased, "A troubled heart".
I think all of humanity understands that, and this needs to be your motivation, not to capture your reality, or everyone's reality, but what we long for and thirst for.
In a sense, a Romantic passage, is meant to be as much about hope as it is about anything, and hope has to do with what we don't have, but long for.
As far as the "emotional space", at times, we can all feel unloved, misunderstood, unappreciated. And none of that may be the case. In reality, we are looking for "that person", in "that setting" to give us validation and approval. And so, any other validation or approval just isn't cutting the mustard.
I happen to believe in love, and that romantic love is not the norm for everyone, but always the ideal that we long for, strive for, and cling to when we've experienced it.
Hey, if there aren't any princes swimming in your pool, find another pool.