I feel like it varies from franchise to franchise, and also by brand. Some brands, like Courtyard or Four Points, might not acknowledge status other than "Thank you for being a ... member." I bet those rooms are available, they just want to try to sell those first before giving them out. Surprisingly, some OTAs have been able to offer guaranteed upgrades for their members, albeit only available at certain "partner" properties