Yes, a lot will depend on your grades, test scores, and overall record. Lots of public universities offer very little aid to OOS students. Some notable exceptions are public universities in New Mexico, Arizona, Alabama, Kansas, Iowa, Nebraska. These states have some very good public universities–after all many of the top students in these states will attend them. But they are not really big destinations for OOS students, so they do offer merit aid to strong OOS students. You can good the school name and merit aid, or something like that, and scroll down to info on OOS students. They will often give you grade and test score cutoffs. Here’s one example:
https://admissions.ku.edu/tuition-scholarship/freshman
Private universities typically have huge “sticker prices,” what it says is the full price to attend. This can often come to $55,000 to $70,000 per year. However, at some schools, relatively few students pay the “sticker price.” Lots of students receive a lot of merit or financial aid.
It sounds like your best bet might be to google “colleges that meet full financial need.” These schools claim you will only pay what you can. Note “claim.” They might come up short, for example saying you can pay 2x dollars but you and your family feel you can only afford x dollars. They might be “need aware,” in that they will only take a certain % of students who will be receiving significant aid. They just can’t afford to be “need blind” and ignore a student’s ability to pay. Also, many are among the most competitive schools (i.e. Harvard).
It’s hard to know where you might be a well-qualified candidate. But look through the lists of schools that meet full financial need, looking for schools where you would be a reasonable applicant and where they might have the programs you are looking for (I don’t know anything about product design).
After a quick search for product design majors, it looks like the Midwest would be your best bet. Least expensive schools for OOS students in general include Northern Michigan University, Kansas University, University of Houston, Appalachian State U., Montclair State U. (New Jersey), Iowa State, University of Wisconsin at Stout (a polytechnic school), Ferris State, Cal State-Long Beach. All of these were on a list of Top 50 product design schools and all had a non-resident tuition under about $22k per year. Of course, your price could be less or more. Run the Net Price Calculator at any school that looks like a potential fit. I note Western Washington and Washington (Seattle) on the list. They would be most affordable for you.
Good luck!