As others have pointed out, your chances are very slim for most of these schools and low for others. You’ll be competing with others who had extenuating circumstances also (sometimes in more heartbreaking situations) with stronger grades than your Sophomore year. You don’t mention your Freishman grades which many of the privates will consider also.
Most of these private schools also don’t take a lot of CC transfers and the out-of-state ones favor those from their states. USC might be the one exception but even for transfers, it favors those in the Trojan Transfer Program.
But you never know unless you try. I strongly suggest you cull your list significantly down to 3-5 schools and really spend the time to find a good fit and explain why you’d be a great student at those schools. This is much better than applying to may schools thinking that increases your odds.
So you might want to reconsider applying to target/safety schools. I promise you there are great schools out there that are probably better fits for you even if they don’t carry the same prestige. You can absolutely succeed at these schools and will probably end up with the same jobs/outcomes as the brand schools on your list. If you still go the CC route, you should look at UCs and Cal States as they are much more receptive to in-state CC transfers and for some schools have guaranteed admissions. UCI is great for the areas you are interested in and has good video-game related programs (even if you don’t pursue CS).
One area of caution I’d add: it’s impressive that you’re top 100 in Madden which is a very popular and competitive game. Given you are Asian, you should approach highlighting video games cautiously as many Asian applicants often talk about that as an EC they are good at. Rightly or wrongly, it fits into a stereotype that I’ve been told by counselors doesn’t really help Asian males in particular. If you can explain your Madden analytical skills as it relates to your field of study in an essay, that is probably the best way to highlight your skills and accomplishments rather than to list it on our ECs prominently without context.