Many churches have professionally trained counsellors. No, they wouldn't tell you to "pray the cancer away" (though there are prosperity-"gospel" preaching churches that would say "donate to make the cancer go away"–beware), but they would counsel you from a biblical perspective, which is extremely helpful. And they would also tell you to seek professional help elsewhere if you need it and they couldn't provide it.