Everyone boils this down to ROI, rankings, who's brother now makes $1,000,000,000,000,000 USD a minute, etc.
I'm going to be the jerk here and tell you to go where you want. Sure, a top *insert arbitrary number here* school might open a few more doors, get you in touch with a few more folks, or any other number of perceived benefits. But at the end of the day, if you hate every waking minute you spend there, it will do you very little good.
Find the school that you fit best in. Which school fits your post-MBA career goals, makes your life easy enough to succeed without being a hermit, and any other metric that is important to you.
There is a top-25 school that I visited and met with some alum and I wouldn't go there if they paid me to. Really. I'd easily take SCU over them without a second thought. Why? The fit at the other school would make both of us miserable. This isn't the golden ticket into the Wonka factory that most people make it out to be. Knowing that, make the best decision for you based on going where you can contribute and succeed.
[/rant off]