Revisiting the tech world after a while. Need your advice and resources to help my journey.

Hi everyonel I'm looking to step into the world of tech again after some time away. I apologize if this isn't the right sub to post this, but I've been lurking on here and you guys are very helpful :)

Some context (feel free to skip this paragraph). I've been depressed for a while. Multiple deaths in my family during my years in university. Plus, I started school during the pandemic and still haven't really recovered from the effects of the chaos. Until recently. (I've tried really hard and gotten myself in a much better place. Yay!) But for the last 5 semesters I haven't been able to pass any of my classes. I don't know how they still haven't kicked me out yet haha.

I've learned that I have a very analytical brain. I need to know the how's and why's. I can't operate on theoreticals or vague concepts. I started computer science in uni with no prior knowledge or history with it. I think that's another reason why I couldn't progress with it, because I didn't really even know what it was. The foundations, how it works... But I revisited it recently, and learned the very bare bones of it for the first time. And now I truly feel ready.

I want to approach it differently though. I'm afraid starting classes again would just lead me down the same path I've had these past 5 semesters (ultimately failing). I'm a purpose-driven and visionary individual. I need to have a reason for all that I do. And that's why I believe I'd work really well in a team setting with a goal to work towards to push me.

That brings me to my question. Would anyone know of any externships/ internships/ part-time work/ training/ absolutely anything where I can apply my learning in a professional environment and gain actual valuable real-world experience in tech jobs? Something for first or second year math and comp sci students because I think that's where my proficiency's at at the moment. Something remote. Or if hybrid, then near the Detroit area and even across the border in southern Ontario. On-site is not completely off the table, though not ideal for personal reasons. Unpaid, or paid (wishful thinking haha, but I'm optimistic it's not impossible).

Or if you have ways/ resources I can use to find these kinds of opportunities myself. I really just want a fresh start where I can actually do something purposeful. Thank you all in advance for your help!