"but some prayed-for patients in the study actually fared worse than the unprayed-for ones. "
Sometimes, the answer is no.
One way I heard it put was: "Sometimes God says No so He can say an even greater Yes later." I know there are prayers that have been answered 'no' for me, and I am probably closer to God now than I ever would have been without that 'no.'