I stayed here for about a month.
Pros:
Proximity to everything - within a 10 minute walk to amazing restaurants, breweries, and grocery stores, and a short drive or streetcar trip to everything else.
Huge space - Much bigger than I thought it would be, could easily house 5-6 people.
Beds - super comfy memory foam mattresses made for some great sleeping!
Cons:
WiFi - it's blazing fast when it works, but the connection would cut out often, making it difficult to stream movies or do video calls.
Noise - Not only is this next to a busy street, but also a railroad and freight ships. I recommend bringing good headphones or earplugs. This was really only an issue during the day though. At night it was not a problem, so if you're planning on spending all day out exploring then it shouldn't be an issue.
Cookware - Limited cookware made it difficult to cook things from scratch, but if you're not planning on cooking there's enough restaurants nearby that you'll never run out of good options.