St. John's is a nice community program in Detroit. The hospital is actually on the east border of Detroit's city limits so you get a great mix of urban + suburban patient population. The residents are all very happy and laid back. You will definetly know how to cut by the end of your residency. If you want to be a general surgeon, it's a great place to train. However, if you're looking for fellowships, maybe an academic center might be for you.
Wayne State University/Detroit Medical Center is still the major medical center in Detroit. It has the only level 1 trauma center in the city: Detroit Receiving Hospital. The current chief class fellowhips looks like this: Duke/Plastics, UWisconsin/CT, U of L/Hand, WashU/Critical Care, Private Practice/Kaiser, Cali, Children's Hospital of Michigan/Peds. But you will work your tail off and be well rewarded.
Henry Ford is an up and coming program with an excellent new chairman with major connections to NASA. Although it is listed as a community program, there is a strong academic feel around the department. They have the best transplant program in Detroit.
Finally, there's Beaumont Hospital which I would say is very similar to Baylor-Dallas. A cozy highly profitable hospital that gives resident's all the perks.
I hope this helps. Take care.