Prestigious schools are worth the connections/friends you will make. Always take it if you are offered to go to Harvard, Princeton, MIT etc;
If you get into your regular state college etc then just do 2 years community first and save money. You won't make friends with wealthy/connected people in the same way you would at a prestigious university.