As a graduate from a "big name" university I would say I am a little biased but honestly it depends on a few things but ultimately comes down to one principle: You will get out of school what you want.

In that I mean, there are people who go to "big name" schools and make ZERO connections and take off after 4 years wondering why they took on 100k in debt. Then there are people who go to small schools (like my wife) who meet lots of great people in their field who eventually will be a great resource for them (eg, my wife now works at Google). She has zero debt and works beside graduates of top schools from around the country.

Now personally, I think that she is the exception and not the rule. The biggest advantage of going to a big name school is that it lets you get your foot in the door. You never have to "hide" the fact that you went to a small school, and there will inevitably be times that you fill out an application and wish that you could put down Stanford/MIT/Univ. of Michigan

Good luck in your decision. Remember that you will probably adjust your career path during college and that a school that offers an overall brilliant student body and faculty will only help you down the road.