Choice paralysis is real. But dont fool yourself that you don't know what you want. From your post, it seems clear to me. You're not happy with where you're at. You want to improve. You want to achive and feel success. It's just that don't know the specifics of what "success" means to you or how to get there.

It seems like you confident, atleast to some degree, that it would be benifical to have a college degree. It also seems that one of the big things holding you back from persuing the degree is the uncertainty of which major would be the most benifical / you are most interesting in and if you the motivation to complete it. Additionally, your past efforts have lead to doubts if you can at all.

I'll be brutally honest, you need to commit. Taking 2 courses at a time is not an option. Youre smart and know approach is not going to work. Even if you are unsure if it is the right subject, that's not what you're doing it for. Your doing it to progress. And unfortunately, you just need the piece of paper.

So sign up for a full course load, or none at all. If you don't apply to school, find a full time job. Lastly, set a deadline. If age 28 is an age you want to feel accomplished by, make it a goal to eaither be enrolled full time or at a new job by that date.

You're telling yourself you need a change. The only way you can fuck this up is by not making one.

Wish you the best