Hampton by Hilton Hotels in Kapolei

We have booked Hampton Inns across the US for over two decades because of the consistent delivery on the core amenities that make for a family friendly hotel. We stayed two nights at this hotel and my score here is based on the second night. Our first night was a horror show that resulted in a comped night. I'll include that information at the bottom but don't think (or at least I hope it doesn't) reflect the hotel in general. Overall - this is a hotel that is trading on a name and the sky high hotel prices on hawaii without providing the appropriate quality of service, amenities or upkeep to deserve your business. Pros: 1) The hotel is located in a shopping plaza in Kapolei. While this offers plentiful restaurants and shops in the close vicinity this is also a significant con for reasons I will describe below. 2) The King/sofabed room was very reasonably sized with a functional fridge and comfortable beds. 3) Apart from one employee (described below) all other staff were friendly and accommodating. Cons: 1) The room otherwise was not convenient. There were no linens for the sofabed (we had to go down to the front desk to request more), minimal pillows etc. Why offer a sofabed but then make it so difficult to use? The bathroom door was absolutely absurd - It was a slider door on a railing on the outside - which meant that you couldn't lock the door and there was a ~ 2 inch gap between door and frame when closed. Better be close friends with those in the room! 2) The location means that you share parking with everyone in the mall. We had to park quite far away from the hotel which is not great for baggage etc. 3) While the food/beverages were all adequate and frequently refilled there was something VERY wrong with the coffee (stale and sour), waffle mix (sour and pasty) and eggs (tasted like salty toothpaste). The common sourness and pasty nature across the three suggest that something is wrong with the water but I would expect that they are checking before serving customers. My kids would eat just about any flavor waffle (and have happily devoured any and all hotel waffles in their time) but both said these were disgusting. The eggs were grainy and pasty - honestly I have never eaten anything like that. I didn't point out these issues as given the other problems experience with the room and the situation described below - I felt that it may have seemed like 'serial complaining”. I figured that if it was fine for everyone else - leave it be and if others felt the same - they would notify the property. The no good-very bad night. 1) We arrived at the hotel later in the evening after an evening flight and so my tired kids went to bed. I jumped in the shower at about 9:30 and noticed that there was only one temperature of water available - Boiling. I thought maybe switching up the input/output may help so I switched from the faucet to the shower and now only cold water was available. I felt that a fu