We used to make summer road trips to Midland Ontario to visit the beaches on Georgian Bay, Lake Huron …
We would stay at the Comfort Suites or Quality Inn for under $100 a night (including taxes etc) …
These are the prices now… with taxes and other fees the cost is closer to $200 a night.
Source: https://www.reservations.com/Hotel/comfort-inn-midland
I think the better option is to find a campground and go camping in a Tent… until it rains.
Some of the most beautiful Beaches are a 13 minute drive from Midland…
Georgian Bay Camping : https://georgianbaypark.com/
Beautiful beaches. Still some good prices in Midland. Probably not for long.