I think the answer will vary depending on the goals and objectives of the person you ask.
If you just want to learn hard skills like accounting, finance, etc, it doesn't really matter too much. Most business schools teach the same core business subjects, which honestly you could learn by taking some evening classes at your local college. Beyond that, some schools may have a particular specialty, research center or professors which align perfectly with your goals, but obviously that requires you to know what you want out of school in the first place. Personally, I agree with Sloan's philosophy that business school is an opportunity to explore different options and many people change their minds once they get into business school.
However, what the top schools give you is network and get you through the front door. If you want to get even more granular, yes there are some small companies and firms that only recruit at Harvard and Stanford or some other subset of their own choosing. However, I'd say this is more due to resources rather than intentional. Sending people to recruit takes a lot of time and resources and if they're not going to get much out of a trip, then they won't send someone. So if a company doesn't recruit at your school, it's up to you to reach out to them. This is very common, and many of my friends got their jobs/internships this way.
In terms of long term benefits, I agree with this post:
3-years-post-mba-a-reflection-141207.html. In the long run, a Wharton or a Harvard degree will get your foot in the door. Or with a Tuck degree, you'll be able to cold call any alum and be welcomed with open arms for a chat. But after that, you have to prove yourself, and people don't really care where you got your degree, and care more about you doing your job well.
and yes, there will always be people who only want to go to Harvard, Stanford etc. I could see that if you live in a particular region why a certain school's name will carry more weight. For example, in Asia, Tuck is virtually unheard of, but everyone there knows Yale. But any top school, as I'm sure you know, will give you great opportunities, and the key is to just pick the one that is right for you.
Just my $0.02.