Just to provide my experience.
It was actually a Category 7 hotel, not Category 6 like I said in the OP.
I checked in at the desk, asked for an upgrade. Desk assistant gave the standard speech, but proceeded to look and then upgraded my room to the next level.