When God's Answer is not What We Wanted

So, I prayed and I prayed and I prayed.
I believed God was listening.
I trusted that He was able to do all things, and move in a mighty way.
I asked Him to do just that. All for HIS glory.
And I was sure HE could.
But He didn't.

Have you ever found yourself in that scenario?
One in which you think you're fully trusting God, totally relying on His power to come through in a particular circumstance, completely surrendered to His perfect will? (Because you're equally certain that His will is in line with yours!)
But when all is said and done - when the dust settles and the smoke clears - you discover that God didn't answer a single prayer you prayed.
And you wonder what on earth (or in heaven!) happened?
Because as far as you can see at the moment, the only reasonable explanation is that God doesn't care.

I have a friend sitting in this position today, and it has me asking, What do we do when God's answer to our heart-wrenching prayers is not the answer we wanted, and certainly not the answer we thought we would receive?
Because, really, we all know God is able to do anything. How many times do we read in the Bible that nothing is too difficult for Him? We know He sees all things and knows all things and is sovereign over all things. I mean, c'mon! He spoke, and the world came into being!
So, why is it, we wonder, that He seems to have been unable (or unwilling?) to accomplish our desires? Doesn't He care???
On the basis of disappointment - and even shock, because we were so sure we knew what the outcome would be - I fully understand those questions. But I've had some time to think about it, **read that: The Holy Spirit has taken the time to speak to my heart** and I have a different outlook right now.
That is, if God truly is all-powerful, if He really can do all things - because He sees all things and knows all things and is sovereign over all things, if we believe He can keep our lives secure for eternity, can we trust Him to tell us No when "yes" would have been the wrong answer?
What I mean is, what if God heard our prayers and listened to our pleas for Him to work thus and so in our circumstance, and what if He watched us laying out what we thought was the best solution to our troubles, and what if He saw us agonizing over how to accomplish it - and heard us crying for help to make it happen? And what if, in the midst of our toil, HE knew the outcome for which we were striving was not the result that would come to pass?
What if HE - who sees and knows all things - had plans which were better than ours?
What if the solution we proposed in our prayer paled in comparison to the will of the One who was listening, and it was the desire of God's heart to bring us to a place of abundance, even though that meant going through a period of hardship first?
If we had faith enough to believe that God really is good, and really does know what He is doing, could our hearts be at peace when He tells us, No?
Maybe, perhaps, could we trust Him when His answer is not the one we wanted?