I think it really depends on individual hotels. I've had stays where an upgraded room was preassigned to me before I got to the hotel and there are others where I wasn't upgraded until I check-in (and sometimes remind them by asking "Just curious, do you have an executive floor at this hotel? ").