Of course it is possible, however, it totally depends on the availability in the hotel. There has to be a standard room available to use a free night award or book with your points. It is risky to just walk in but I guess its luck of the draw that way. The front desk will contact spg to complete reservation for you. A quick call to spg before you go would be the best bet.