The location is definitely the biggest perk for this place. We stayed during a pretty warm week in February, and were able to walk all around RiNo and to Union Station and downtown no problem, in fact, most places were a shorter walk than I was expecting. If you wanted to Uber/Lyft, about $10 should get you most anywhere you want to go, $30 to airport. We didn't hear any noise from the bar next door, plenty quiet inside the unit if you're worried about sleep.
The Wifi worked great too, able to get some work done and stream Netflix. There's only a TV in the bedroom and it doesn't have many channels, so recommmend going out if you're trying to watch a game or something (we stayed over Super Bowl Sunday).