We don't always get what we want, you're quite right, David. I had an ischemic, (blood clot) stroke over ten years ago that left me over half blind and so I was prohibited from driving. I prayed often for recovery of the left peripheral vision lost in both eyes and in a "slow miracle" way did get some recovery. Now I'm a little less than half blind but I remain hesitant to drive anything other than a lawn tractor. I've asked God through Jesus' name for other things such as a used house or snow blower or tractor and providentially usually got what I wanted for a reasonable price. I refinished the cupboards in this house after I bought it twenty years ago but did a rather poor job of applying the last coat of varnish. If I had waited a day longer to let it dry more they would have been smoother. Well anyway, the idea that I would need to refinish them yet again was repulsive So I began to pray to God in Jesus name to smooth them for me. Although it has taken twenty years they slowly smoothed by themselves. Although we tend to think of the objects around us as unchangeable we mustn't preclude the possibility that they might be slightly malleable to comply in time with our desire/intention. Is this, our reality in fact an illusion produced in the mind of Our Creator for our amusement and pastime? After all, have we not Eternity?I believe there is some evidence that prayer in a general sense works in a statistical sense, but it most certainly isn't a case of "Ask and ye shall receive, knock and the door shall be opened to you!
We need to face the actual evidence.