Weren’t the answers when you asked this 2 weeks ago sufficient? Middlebury or Cornell? HELP!
In any event you seem to misunderstand the medical school flow. Medical schools accept students and turn them into trainee doctors; specialization such as psychiatry happens in residency after med school, not in med school. Consequently even if you are right that “Middlebury isn’t ranked very high for psychology” it has absolutely no bearing on your future.