Are hotels cheaper if you book closer to the check-in date?

No, they're not generally cheaper. It's more likely that the cheaper rooms will sell out and you'll be left with more expensive rooms or no vacancy at all - especially if you're going to a popular destination or for a special event.