I don't have a dog, but my cat is helpful because he refuses to let me stay in bed too long.
He'll sit his 20-pound butt on my head, purring in my ear, until I get up and feed him. If that doesn't do it, then he will bite me and run away because he knows
that will get me moving.
My cat is like the a-hole version of a service dog. He doesn't make me feel better, but demands I pay attention to him instead of sitting there feeling bad. He's not too useful at other service tasks, though.