Stayed at the Auberge during my recent vacation. The location is pretty ideal, being close to public transit, Rue Ste-Catharines and within walking distance of the VIA Rail station and many other downtown spots.
The bar downstairs is a nice place to sit back with a cold drink after a day of exploring, but the twice weekly bar tours are a great way to get out and meet some of your fellow travelers as well.
It's not five-star accommodation, that's for sure, but for what they do, they do it extremely well.