Very nuanced and complicated question. I would say like most things it depends. It depends upon what you want to do after medical school--do you want a job in academics or to just work clinically as a physician or do you want an administrative job. Depending upon how you answer this will guide you as to what medical school you should go to. If you just want to see patients and work as a primary care doctor then any US medical school will suffice. If you want an academic career then you should look to a tp tier medical school with opportunities for academic and research involvement. If you want to do medical administration then you may or may not need to attend medical school, its just how you would approach it.
also depending upon the specialty--some super specialized doctors only can work at larger university based hospitals--if that's the case then where you go to medical school may matter but where you decide on doing your fellowship would matter even more.