I used to feel grateful and a little touched.. now I almost feel insulted. It strikes me as a completely worthless notion. Like they couldn't be bothered trying to actively console you or be helpful at all, they'll just be praying for you. I suppose maybe I'm bitter.
Sometimes that's really all I can do for someone. If you had a problem that you mentioned to us on here, I'd pray for you and I'd let you know I was doing so, but I doubt you'd want to call me up or email me to talk it out. There'd be a limit on what I could do for you in a practical sense, and sometimes praying for you is all I can actually do.
That said, last night I had a mate who was having a rough time (interstate), and I sent him a message saying that if he wanted to call, he should do so and that it didn't matter what time and he shouldn't think twice about waking me if he needs to talk. Then I slept with the phone by my bed. It's not that I can't be bothered consoling someone if they need it and if it's something I can actually do, it's just that sometimes praying for someone is all I can do for them.