I've never seen any points based upgrade awards at an RC. I have been offered cash upgrades though. The Cayman RC offered to upgrade me a per night charge to upgrade to either an oceanfront or club room.

If you are interested in paying for an upgrade, I would suggest calling the hotel and ask them about it.