If you no show as you have agreed, your contract --- and that is what it is -- is subject to cancellation. There is no policy for this, that is the nature of contracts.
Whether the specific locality chooses to honor the reservation as booked is really its own decision. Needless to say, at busy locations during high season, there may not be a vehicle to be had.