I am not sure about the SS memeber cruise, but I have paid for an upgrade at port before. I booked the best Catagory I could with the points and cash I had on hand at the time of booking. When I got to port, I asked about paying for an upgrade. They had me check-in and then sent me to the end of the counter. There they checked availability and then told me the price differences.