To be fair to Hilton, I wanted to update this. I checked in at the same property Thursday and waiting for me was a letter of apology from the manager and a certificate for a free night's stay there (good only thru December).
This was as a result of an e-mail I wrote to Hilton customer service who then forwarded it to the hotel in question. I appreciate Hilton's effort to make amends but would prefer to be listened to by the front desk staff at the time of complaint rather than making the extra effort later.