Huron Church Road is the streeet running south from the bridge and has lots of hotels and motels. However other than the Econo lodge I am not sure about overnight rates.
Econolodge is about $75.00 overnight. If you want a short stay motel than $25 to 45 for 2 to 4 hours is the range. At least during the day parking is no problem. If you want overnight, Put in a $40 to 50 bid on Priceline for ...