This feeling of being a boring burden was the “valley of the shadow” for me, and it is a lonely, frightening and disorienting place to be. I found help from my spouse and family, from friends, and from a therapist and antidepressants. The pain is a breathtaking addition to all of the emotional and existential dislocation we feel. I agree with John’s note that focusing on what I can do has helped greatly. Gradually I rejoined a club and a chorus, and I stay in today, not in the scary future picture my imagination can create. This takes practice and the company of like-minded people. It also takes time, and spiritual, emotional and physical therapy for me.
I hope this is of some help and comfort. You are not alone.