From a sufferer's POV:
For the love of all things holy: SPELL IT OUT.
If you want me to do something for you that isn't as obvious as lugging the beer up from the cellar, say it with all the subtlety of a hammer to the face.
"Say nice things and fetch stuff for me" would simply leave me standing there like 5'8'' of pure AWKWARD, probably saying stuff like "the color of that bandage looks really good on you" and fetching a vase of flowers from another room to put them down next to you.
(And yes, I probably would try to break the awkwardness by making it worse with looooong stories about the various ways I screwed up my body in the past. Simply because I wouldn't know what else to say.)
I'm absolutely useless in situations like that. That feeling of helplessness is a HUGE problem and unbelievably stressful to me, especially paired with "what if I screw this up!", "why THEM and not ME" and several other fun thoughts like that. When there's something I know I can't fix, I won't know what to do with it.
Used to be pretty good at this. Then the Beast moved its stuff into the house and a-flyin' out the window that (and many other things that seem relatively straight forward to other people) went.
From a supporter's POV:
This?
My guy basically has two modes - 1) suck it up Princess and 2) call a code blue.
FACT.
My guy is permanently stuck on option #2. #1 doesn't even seem to exist in his world when it comes to people he cares about.
When I'm in a bad place, physically or mentally, and allow him to notice, he'll worry and fuss and spend day and night trying to come up with solutions to make it better and save my world.
Of course there never really are any ways to "fix it" to the extent he'd WANT it to be fixed, so he gets more and more agitated until he finally pushes himself into an episode, leading to days, weeks or even months of all things bad for both of us.
So what I do before he can option-#2 us both into the hole is...I option-#1 him right out of the issue.
It certainly isn't the best approach, some things just aren't made to be hidden or "sucked up", but it's what I have to do if I want to keep us out of that near-inescapable loop of us stressing each other out over and over again, worse with every round. He's the same way when he's the one having problems - only that his usually are way too big to hide, which means we're fairly familiar with that particular vicious circle.
What I'm trying to say is...try to see the positives in his behavior.
No, it isn't what you need, and certainly not ideal, but at least his being out of his depth with the challenge at hand might be made better by communicating your needs openly and clearly.
Once they get into that - impossible to live up to - frame of mind where they have got to be the savior of your world or die trying? It's just about impossible to get them out of it.
If this was the first time he found himself faced with a situation like this, it's not all that surprising that he didn't handle it overly well, but that can be worked on.
Here's wishing you a speedy recovery with as little awkwardness in the process as possible. :)