Another data point. We just got back from a cruise starting/ending in Miami. Applied a SNA one night to the JW Marriott Marquis Miami, no upgrade though I think it was a busy weekend as hotel was showing sold out.
We also had a 2 night stay at the St.Rgis Bal Harbour at the end of our cruise. Awesome elite recognition here - I had applied a two night SNA and it cleared the day before. When I checked in at the hotel the next day, they had upgraded my family of three to the two bedroom suite! I did have to pay the daily resort fee of $40 plus ‘other room’ fee of $50 a night but it was worth it for the experience.