I once got an upgrade at the Dolphin in precisely this way, arriving about midnight. Everything else was full, so they had to put me on the concierge floor! The trick is to show up *just before* they run out of rooms, not *just after*!
Keep in mind that if they are near capacity, you could be "reassigned" to the Swan.