I don’t know of anyone who thinks prayer is bad unless they are just radical atheists. Just remember the words of C.S. Lewis, prayer doesn’t change God, it changes you.
There are prayers which might be considered bad when asking for things God would not find appropriate (e.g., asking for someone’s death). Prayers for healing would always be good in God’s eyes from all that I know from reading the Bible.