This was me. I got into and thrived at Community College. My strengths shone there and I transferred to a great 4 year state school. My parents were poor and couldn’t sign any loans for me and had no money to give me, so I had to rely on true need based aid. Cc/State School were my only options as an average student on paper. There were many many many kids like me out there doing great as well at state schools!
You might do well at small private liberal arts schools as well. Research those, in NY colleges like LeMoyne, Utica U, etc…not sure what state you live in but small privates may not be super selective and have plenty of aid if your parents SAI is 0. You can use a fee waiver on common app, so nothing to lose!
ALSO, very important, you may be eligible for HEOP. Please research. I call it a little magic for students who qualify financially. It is for kids who have not had the best opportunities but have potential! This could help you be admitted to places you are just below academically. It “softens” the GAP requirements and helps disadvantaged kids gain advantages and equal the playing field a bit. Plus this program could help you be all that you have potential to be at college.