I spend about 100 nights a year in hotels and I've maybe had a hotel not have a reserved room for me once in ten or more years.

>the cancellation period is actually one day prior to arrival

Unfortunately, a lot of chains are increasing their cancellation window. In addition, there seems to be a fairly significant trend toward hotels (especially the chains) offering substantial discounts for non-cancelable reservations.