It does not make sence too me either. Who did you talk to ? Reception of the hotel or the reservation center in Mainz ? I don't understand why - if you paid for a higher room category - you would then not be entitled to RC access. Especially in a property with week end packages and G1 bonus.
Looks like this can be easily solved upon check in by the front office.
Enjoy Cologne !