Nothing wrong with the downtown CY for the price -- among other things the robot People Mover drives right through the building and will take you up to Comerica Park, etc. -- but the neighborhood is barren and blighted and does not feel entirely safe.
I also have enjoyed the Marriott out at DTW.