If given one task at work, I find it very hard to succeed (difficult to sustain interest). I cant do things linearly, I am horrible at planning and spacing out work. Those are kinda essential and expected while working in a team. One thing that helps is to be aware of these limitations and set realistic goals. Don't let your manager ask about it, its better to get an idea of the expectations from them. The self work part of this is very personal.

Having a side project might help. Sometimes trying to be a leader in the team could be very up lifting. You will have to find the part/piece of tech that you can enjoy a lot. There is space for us in tech. Go for devops if its your thing.

In my case I think if use my skills and get a paycheck to help my family, itis a huge motivator. Give yourself the time and grace to work on yourself, that will help you at any job.

Hope this helps.