On top of your reservation being cancelled you will charged for the night that you missed. Also, you might not have a room to check into the next day if the hotel is completely sold out. So if you are ever going to arrive at a hotel around midnight or later always contact them and let them know.