We stayed in room 108 and the view was the Guggenheim was nice. The Shower head and water pressure was wonderful. The bed sank in the middle and that was the only bad thing about this place.
Regarding Checkin: my recommendation is that once you receive the link to do the online checkin - do it at least 3 hours before checkin. Also set the expectations that you will receive an email at 3pm with the code to unlock the door. The address given is for the condos of the building, but the apartment entrance is around the corner going toward the Guggenheim. Look for the sign that says Lubiere. That is the enterance where you enter your code.