Most of the hotels/motels around Detroit Metro Airport (DTW) are 2 or 3 stars, and on Priceline are often pretty cheap (unless some convention is in town). They generally go for $30-50 per night according to biddingfortravel or betterbidding. You can even get the 4 star Westin for $99 some nights.

DTW is a major NW hub, and according to your signature you are interested in Skyteam.