The typical horror story of insurmountable college debt of hundreds of thousands of dollars comes from people who go to grad school, where the loans are uncapped, so that they can reach as high as fifty grand a year or more, as opposed to undergrad, where loans are capped to around ten grand a year. Colleges for that reason have to be more generous with financial aid to undergrads.
Unfunded grad school is pretty much never worth it for that reason, especially for non-STEM fields (but even for STEM, it's still pricey enough that it probably isn't worth paying full price). Med school is also pricey, but high salaries make up for that, and what I've heard of law school is that it isn't worth the cost if you aren't going to a top 20 school.
But as for specifically undergraduate education, I do think the financials make it worth it in many cases, but it's misleading to generalise across all majors. 30k of debt for a computer science degree is likely worth it, sure. Is it worth it for an English degree? Debatable, but 30k of debt at least isn't going to financially hobble someone for the rest of their life. Is it worth paying full sticker price (if e.g. the student doesn't qualify for financial aid) for a sociology degree? I think that would be dubious.