If you're hoping to snag an upgrade, checking in towards the day might be your answer.
According to Pavini, since hotels have a better sense of occupancy by that point, they are more likely to offer upgrades that are still available.