should people pay more for a better school?

The devil is in the details. How much would you have to take out in loans for the “better” college? How different are the two colleges in your area of interest? What are the job prospects from.both colleges in your major? etc. You don’t provide nearly enough information for anyone to provide meaningful advice other than you should not take on a ton of student debt.