I leveraged my Tier II undergraduate into a tier I graduate school experience and am now a PI/lead at a large defense contractor.
If you are smart,diligent and stay out of too much trouble, you can take advantage of the cheaper/smaller state schools for undergraduate and push yourself where you want to go. It's not Princeton or MIT but there is still plenty of affordable opportunity (especially in tech and engineering).
Granted my college experience, didn't have the glamour of the division 1 football tailgates, or the excitement of a big city, but those things cost extra.
[0] It was in a small town ~30,000, so local 3 bedroom apartment was $550/mo (split 3 was was ~190 a person), and tuition was about $4000 a semester. Currently tuition is $5000/semester and you can get $5000/year from the lottery scholarship.