Unless you're exceptionally bright, poor, or unique, it isn't affordable. The vast majority of kids (read: average, middle class folks) get stuck paying 85% of the bill.
I ended up going to a private school with tuition of around $30k/year. I got $16k/year in merit-based scholarships based solely on my work in HS... as a white, middle-class male. So I got stuck with 50% of the bill; my parents were kind enough to help with half of that. School-mandated co-op jobs (total of 1 year of them, in my case) definitely helped with the rest--that's part of the trade-off. By going to a well-known but more expensive school, I probably had an easier time getting good internships, which in turn helped pay off the higher tuition.
I think university is entirely worth it if you can realistically afford it. I met amazing people, learned some very interesting things that I would not have been exposed to if I were self-taught (Mentor Graphics software licenses are not cheap), and yes, got a piece of paper that says I hung around a certain school long enough to be given a Masters degree. I've got about $30k in debt. It's doable.
The local state school where I grew up runs about $1600/quarter. When I applied as a backup, they offered to basically waive my tuition because my grades and SAT score were good. Bright but poor kids should at least be able to get into state school for extremely low tuition.