I just finished a *stay* at the Yotel - and I loved it. If what you're looking for is a cookie cutter hotel room, you're not going to like it. Granted it's not a standard sized room at a hotel, but there is plenty of room for what you need and the showers/linens are great! You can order food from the Galley.
It is still being used by CO for arrivals: I saw someone presenting his boarding pass at the door. I'm not sure about the hauling luggage up and down stairs: there is a ramp at the door, and my cabin had no stairs.
Although I didn't use it as an arrivals facility, I did ask the concierge who met my flight how to get to it, and she gave very clear and precise directions.
I also had a drink at the Hilton, and for arrivals I'd much prefer the Yotel. The Hilton is a 15 minute walk from the terminal, and at 6 am in the morning, after a red eye, that would be a trek.