No, I want someone who will act. What you are describing (...just be with you) is what God is doing.
Read carefully the posts everyone else has given; there's a lot of wisdom on this thread that may be easy to overlook. What I'm about to say is only as an addition to the other users' input, as what they have to say is very good to understand, though I will avoid repeating it.
Consider all the people Jesus healed. Blindness, possession, even death wasn't too much for the Power of God to make well. Lazarus, Jairus' daughter, and so many others....but they all died. Died again, in some cases, and I wonder how many that came to faith through miracles lost their faith in their dying days.
The point of all of this isn't to heal people of temporal maladies; it's so that people may see the power of God & be elevated to the Kingdom of Heaven. Look at the suffering of Paul, of Josephine Bakita, Maria Goretti, or any number of dedicated Christians through history. Remember that many of the Psalms that sing of the comfort & love you're questioning were written by David, a man who spent a great deal of his life being a righteous man hunted mercilessly by a variety of enemies. Read 1 & 2 Samuel; the man who wrote these words of comfort was not a comfortable man!
In any religion, we have to look beyond the things of this world for a deeper spiritual meaning. God being with you in your suffering is much more profound than we'll ever give Him credit for. Sometimes, we understand that pain is necessary to achieve a higher good; surgeons are paid thousands of dollars for this purpose. Imagine surgery & dentistry in the days before anesthesia! Even if we don't understand why, there still is reason to hope that a good God is like a good doctor, lovingly doing something that hurts at the time, but even if I don't understand why an organ in my body or a person in my life needs removed, I will still trust God & still trust the doctor that they know what they're doing. By the way, a lot of this is from C. S. Lewis' book,
A Grief Observed. He tackles this very question, not by choice, but by the death of his beloved wife. The ensuing spiritual struggle makes up the short by powerful story.
I know your pain, it does feel like nothing many times. I could give you trite sayings like everyone else but to tell the truth I have no answers and wonder what you have asked many times. Yet here I am still
"From this time many of his disciples turned back and no longer followed him. “You do not want to leave too, do you?” Jesus asked the Twelve. Simon Peter answered him, “Lord, to whom shall we go?..." --John 6
There was a point last year where my head was swimming in the evils of the world. 2 of my college classes were Advanced Forensic Psychology & a class on serial killers. My best friend had a homicidal stalker that may still be after her & her whole family. I was watching a good amount of the show Criminal Minds. I had been immersed in a lot about human trafficking, as my aforementioned friend had spent a summer in Thailand working against it, and still struggles with PTSD from the experience. I was so deep in everything awful in the world that I couldn't even see God. I had no reason to believe.
This is what my prayers turned into....
“You do not want to leave too, do you?” Jesus asked, with pain in His eyes, but understanding as well. “Lord," I replied, hardly able to speak, desperation & confusion as my only companions, "Where else would I go?"
Switching to atheism, though more logically sound at this point, would've solved nothing. There was still a chance that God was doing something, and I'd heard a lot about people who endure through great troubles & gain great spiritual rewards. I had no reason to believe in God, but it would've only made my despair worse if I turned away from Him.
I can't answer why God would allow evil to the extent that He does. I can, actually, but an intellectual answer hardly satisfies a crushed spirit. After this experience was when I saw more of the good that shone through this darkness. The evils of the modern slave traders cannot stop the indescribable love of the people who voluntarily take on the hell of human trafficking that others may be saved. Someone who, by their own choosing, steps into the worst of humanity, that through their sacrifice, some may be saved...sound familiar?
I don't expect this to be a full response to your question; honestly, I don't know if you'll ever find one. But let your mind prayerfully ponder this for awhile...you can almost hear the pain & confusion in Peter's voice as he replies, not with understanding of what Jesus was teaching, but with the realization that no other option would do him any good.
For what it's worth....peace be with you.