Yes, and the relative generosity of some hotels is the reason many diamond members return to them.
What’s interesting is that the “generous” hotels can be consistently generous and vice versa.
Having many different classes of rooms at many different prices means that the relative value of an upgrade could be tiny, or could be substantial.