I also felt bad about it for a while. I'm a scientist by heart, 100 %, and I knew I had the intellect to get a degree. I thought the reason why I didn't anyway was because I was also some kind of assclown.

Fortunately, my degree attempt coincided with a useful obsession, for a change: My old programming hobby. The obsession ended like all the others, but the knowledge that stuck from going 14 hours per day was enough to get food on the table for decades to come.

It's just now that I realise I never was an assclown, and I never "decided" to quit my degree. It was ADHD, and I never stood a chance, not with "discipline" or just "deciding" alone. Knowing it, with treatment plus self-acquired methods & tricks, it would have been an option back then, and maybe I'll go for it again, if time allows.

Pushing yourself is good, but it needs to be a "relative" push based on your ability. Could be 5 hours of hard studying / cleaning / whatever for some. For others, or the same person on a different day, getting one bag of garbage and filling it, or studying 25 minutes is already the best.

Your post is a good start to collect ideas for moving forward, at your own pace. It won't be easy, but your situation is objectively not as bad as it feels to you. Maybe it can be a small step towards improving your condition?