I think it depends on the agent and the property.
It's worth being a diamond for hotels like the Cavaliri.
I also have had the diamond esk get me out of paying a "no show" penalty.