The best answer is probably 'it varies' based on region, occupancy and also the policies of the individual hotel. Two RC stays in the last month - RC Doha was upgraded from Club Room to Executive Suite (with an 8am check in time), RC Langkawi was upgraded from a standard room to a villa (which is equivalent to getting a suite upgrade).