I'd have to agree that MGH/McLean is considered the top program in Psychiatry. While this is a hotly contested topic, US News and World Report puts out its annual "Honor Roll" of America's Best Hospitals. Although any ranking system has its flaws in trying to place a numerical order on institutions with different focuses, this is still the most widely read and accepted of the ranking surveys. It's the one consumed by the lay public.
If you look in the methodology for these 2007 rankings, they surveyed psychiatrists and asked them their opinion as to which hospitals had the best reputation for managing challenging and rare cases. Here they are for psychiatry:
#1 Massachusetts General Hospital, Boston 36.1%
#2 Johns Hopkins Hospital, Baltimore 28.3%
#3 McLean Hospital, Belmont, Mass. 23.0%
#4 New York-Presbyterian Univ. Hosp. of Columbia and Cornell 21.0%
#5 UCLA's Neuropsychiatric Hospital, Los Angeles 20.9%
#6 Sheppard and Enoch Pratt Hospital, Baltimore 15.9%
#7 Menninger Clinic, Houston 14.0%
#8 Mayo Clinic, Rochester, Minn. 13.1%
#9 Yale-New Haven Hospital, New Haven, Conn. 11.5%
#10 Stanford Hospital and Clinics, Stanford, Calif. 10.9%
If you want to see the link, here it is:
http://health.usnews.com/usnews/health/best-hospitals/search.php?spec=reppsyc