I have not seen upgrade offers at check-in in years, only the advance upgrade offers either online or in the app.
If you check-in at the desk in person, they'll only be able to offer the cost to reticket in biz which will likely be huge bucks as it'll be a walk-up same day fare at whatever inventory is available for sale.