Your options are rather limited in much of metro Detroit for Hotels... you stayed at Georgian Inn in Roseville... there are a cluster of about 6 hotels in the 13 Mile/Little Mack area of Roseville.

There's also the Shorecrest in SCS, but that's nothing special... ditto for the hotel along the I-94 Service Drive in Harper Woods.

There are also a few hotels along the Van Dyck corridor north of 12 Mile.

Outside of downtown... your best hotel options are probably in Troy. Southfield used to be a contender... but not anymore.

Interestingly enough there are no hotels in any of the Grosse Pointes.

You might want to try The Inn On Ferry Street... 4 large historic houses [[and 2 carriage houses) that have been converted to a Bed & Breakfast type of lodging... it is located 1 block north of the DIA... 1/2 block east of Woodward.