There are a lot of it depends. If you are going to be a retail worker all your life there is no reason to go to college. A music degree has questionable value on its own, but many people get them understanding that "any degree" is needed for some good jobs and those that find those do well enough (your generals and non-major electives are important). The school matters - Harvard is expensive but the networking can be worth it if you network well in school. State schools tend to be a lot cheaper than private or out of state as well, and generally pretty good. Scholarships enter in as well. Degrees like Engineering or Medical doctor tend to have a much better ROI long term, but only if you pick the right one and pass.
But you need to make your own decisions. For some your best ROI is dropping out of school at 16 - but for the vast majority more school will be worth it.
This would be fun to model. Lifetime earnings are higher for those who have more education, but there's potentially decades of servicing a potential mountain of non-dischargeable debt to consider (potentially decreasing post-college investment ability) too.
I don't know the first thing about student loans (interest rates, amortization periods). I never had one. I just search-engined 2025 federal student loan rates and I'm blown away by the interest rates. It looks like avoiding student loans at all costs is the way to go.
I wonder if spending a few years working (especially if your parents are able to continue to house you and pay for health insurance) and contributing to a 529 plan might meaningfully decrease the overall cost, albeit at the "penalty" of starting college later in life (at, say, 22 instead of 18).