I think if you have a good personality and can network well, you should pursue the location you want, knowing you can maneuver once you are inside the walls. If not, then perhaps consider the ranked program. This experience is going to more about acquiring knowledge and taking this specific moment to go out and make your moves, rather than availing yourself of a super elite recruiting pipeline. I'm not someone to say don't go to a program outside the top 25, just be very entrepreneurial about the experience, regardless of your career goals.
From what you are saying, I'm thinking San Fran is probably the way to go. But don't be afraid to ask yourself the tough questions.
Paul Lanzillotti | Founder| About | firstname.lastname@example.org | 877.866.9251
Schedule a Consultation | Twitter | Blog
Download "How To Apply" Guides | INSEAD | Columbia | Harvard | Wharton