Please help; Where should I attend college?

paying wise, my family gets no financial aid and my mom can contribute about $100,000 before I have to take out loans.

My mom says I should go wherever I will enjoy and then I will figure out the debt later but I keep on hearing horror stories about college debt and how it wasn’t worth it.

my concern about Manhattan college is the reputation and the size. Honestly, I loved Texas but its expensive and its definitly a scarier experience than going to Manhattan and I’m worried I won’t be able to adjust.