This is a great location! Our view from the balcony included both the water and CN tower.
I highly recommend buying a day pass for public transportation and catching the 509 streetcar to anywhere in the city.