I have always assumed that the “ redemption with points upgrade” simply allows you to pay for an upgraded room by paying more points for the room than you would for the standard room. I think I have done that, but can’t remember for sure. I’ve definitely used the “redemption with cash upgrade” though, and you don’t earn points for the cash part. Otherwise, there’s been no difference in the stay.