The room was very dark and stuffy, but it was clean and had all the amenities that one would need.
There is noise due to the tram, the construction site next door and the old old building, but it wasn't too bad, we were able to sleep quite well. If you're a light sleeper, then it might be too noisy though.
Location is great - walking distance to so many great restaurants (The Mission, Punchbowl Social, 10 Barrels, Breakfast Republic) and other areas (Gaslamp quarter, Horton Plaza, other shops) plus there's a tram stop just 2min away.
There are many homeless people but we never felt unsafe.
We stayed for 11 nights, but we would not recommend to stay that long though, as we think the room is only suitable for short stays/trips. Great for short stays though.