I would recommend the Hilton Garden Inn Detroit Metro Airport. The hotel is only minutes from DTW and you can use their shuttle to get you to and from the airport as well as your rental agency if needed. The hotel is clean and the staff is very friendly.
Joe F