Is it worth it? Well, I'm not sure.
I currently go to a state university for about $13,000 a year (room and board included) - a bargain compared to pretty much any school in the region.
I switched majors and realized that while my school offers that major, it is not well known for it. This is an engineering, science, and architecture school - and any major in the social sciences is not nearly as strong. So next year I plan to go to a university that IS well known for my major. I believe that the strength of the major will bring in better professors, help me make better connections, and provide better chances for employment.
My cousin, on the other hand, currently attends a tiny private college with a price tag around $42,000 a year (and increasing). It's a lovely school, but I could never justify spending that much. He loves the atmosphere that small colleges have, and thinks that his school's reputation for being top-notch will help him snag a job, even if he'll have quite a bit more debt that I will have once we both finish.
So really...you have to determine how much you value the prestige and connections the school has. These can be key, but it doesn't mean that if your school lacks either that you'll end up in a bad place. Plenty of people go to community colleges and become extremely successful. Also - many of these expensive colleges give out HUGE scholarships. My cousin got a single scholarship for $18,000 based on an essay alone. That's something that cheaper public universities lack.