Decent place to stay - for the money
This location is in the flight path for arriving flights at DTW.
Although there was seemigly little done during the recent remodel to deaden the sound of inbound aircraft, the last flights arriving are around 10pm, so you should still be able to get a decent nights sleep.
The rooms are clean and decently appointed for the price.
As far as I am concerned, the location of this hotel makes it most suitable for their park/sleep/fly deal for about $80 per night.
That gets your car in the "yellow bus" airlines parking lot, directly accross the street, so you will get a quick transport to/from the airport.