Got an engineering degree at a state university. Even at out-of-state tuition rates, it most definitely paid for itself in my first two years of employment.
STEM degree is 1000% worth it. If you have any aptitude for it at all, I think it's your best avenue for upward economic mobility. It future-proofs you as well. As more and more labor (and I don't just mean manual, but service and clerical too) is being done by machines, you want to be the one building, fixing, or running the machines.
I think these days college may be too expensive to be used for post-adolescent self discovery. You need to go in targeting a specific job and having already calculated the return on investment.
For someone who's a writer or an artist and profits directly from the merit of his or her work? A much less certain investment.