If you are a smart enough student that you would gain admission to one of the highly-ranked flagship universities of another state, you are going to win scholarships to private schools too. The lower the rankings you are willing to go, the better scholarships you can get.
You can relocate to get in-state benefits but it may take awhile as states put conditions (e.g. living there for a year first, having a a job, etc) specifically to prevent people doing this.
From https://www.newsobserver.com/news/local/education/article239..., $800 million from North Carolina tax payers to universities it sounds like.
Meanwhile, Germany is re-introducing fees for non EU residents: https://www.studying-in-germany.org/germany-will-reintroduce....
€1500 per semester. Nothing compared to zzz USA or even UK fees.
Also, a lot of state systems have good schools: UC Berkeley, UMass Amherst, UIUC, UT Austin, and UW Madison come to mind.
I have relatives that were able to pay for their tuition with part-time jobs in college. Today, I'd have to take out a small mortgage just for a liberal arts degree.
Schools bear a lot of responsibility but then we can't ignore the role state governments have played by drastically slashing funding over the past 10+ years. Probably only going to get cut further in the COVID environment.
Purdue University hasn't raised tuition in something like 5+ years and is also still affordable. It's not Ivy league by any means but it's a great school. You need government and administrators/boards willing to support this though, 99% won't
Something external needs to happen to stop rapid rise in tuition. Maybe it will be COVID. Maybe state governments will reign in the profligate spending of their universities. They aren't going to do it themselves (at least top Universities, schools at the bottom of the food chain could definitely go bankrupt.)