Major Advice? Weird situation.. [going back to college]

Hi. First, a little background: I’m a 22, F, USA. I turn 23 this fall. This might get a little ‘off my chest’ -like, I’m sorry.

I failed out of an art degree nearly two years ago because of foreclosure and homelessness, I was put on academic probation, and my college transcript looks terrible. [In an Arts degree.]
I was mainly a digital/3D artist going for games or special effects. After getting somewhat back on track with my financial situation and some self-reflection, I realized I don’t really love art that much, or I don’t really like studying it, I’ve never stopped teaching myself new things. I still daydream about the way certain things would work as games, though I haven’t touched a videogame in years, and I still sketch profusely, so in some way I am an “artist”, but I’m not sure it’s any more than a hobby at this point.

I did enjoy college and still would like to go and pursue a degree. I went straight into art without thinking because I was told I was good at drawing, and feel like I screwed up. Now I’d like a change, but I’m not sure what I really like enough to pay to study for the next 4 years.
I don’t consider myself to be very creative in coming up with the ‘big picture’ or anything groundbreaking, but I’ve found I love working alongside larger projects. I’m slightly interested in filmmaking/videography, digital and practical fx, cinematography… I like working with tech. I really enjoy nature/animals as well and find that the environment/climate change has also been a prevalent topic/interest of mine throughout my life. I like writing, as well, both narrative and non fiction/technical. I am told I have a knack for understanding people from a psychological veiwpoint as well, and I love thinking through people’s motives.

I have relatively good grades, sophomore year I took a heavy hit of abuse from my father and came out with a 1.5, though I was told it’s mostly the last 2 years that count, and my 11-12’th gpa was a 3.7 avg.
I wasn’t able to take the SAT in high school due to more domestic problems, so I took the June 1st test this year in hopes to get back in university. I’m a good, serious student, if even straightedge-y when I’m not being abused at home or struggling with money at home and I hope universities would be able to see that.

I want to start over and I do need a job out of college. It doesn’t need to be 6 figure, I just do not want to stagnate at a desk job, and I don’t feel like I’d like to work a trade much. I need to be creatively stimulated. I think I enjoy dynamic environments. All states are game, and I was even thinking [seriously] about trying to study in Canada. [I have nothing left after my family lost the house.] I know it’s in no one’s hands to choose a major for me, but I would like to hear any suggestions or advice. And if you read all that, thanks.

I’m sorry you’ve had so many challenges. Are you in a safe place now?

What state are you in? Are there any community colleges near you? They have advisors who can help you.