Counterproductive? No, not really. It's either antagonistic, if there truly is a god listening to our prayers, or it's just pointless for anything other than self therapy, if he is the only one hearing his own prayers.