What universities should I aim for? 2.6 GPA from Brazilian School, US resident.

Get your HS records from Brazil formally evaluated by WES or an equivalent organization (https://www.wes.org/) your GPA might not be as bad as you think.

Every state has some kind of guaranteed transfer/articulation agreement for at least some majors with the public universities in that state. You can choose the state you want to study in based on that. You also can just stay where you are, focus on mastering Academic English and on keeping up your GPA, then transfer from your local CC to just about anywhere in the US.

What is your local CC? Miami Dade has an excellent national reputation. If that is where you would need to start studying, it would not be a bad thing.

Grad school admission is not particularly dependent on where you finish your degree. Rather it is dependent on how you finish. If you have excellent grades, a good GRE score, and excellent letters of recommendation from your professors, you will have lots of good options for grad school.

Lastly, if you don’t want to go to frat parties, just don’t go. No one can force you to do that. Hang out at the library or in the lab and you will meet other people who share your interests.