I found this to be an issue in the past as it was better to check in at the hotel for upgrades purposes. Recently however it seems to be improved. You do get a message when you check in via the app that because of your status and if there is availability, you will be upgraded.
And hotels do upgrade. I have been upgraded 4 out of 4 stays recently