This is an ideal spot to explore Vancouver from. You're blocks from Gastown, and about a mile from both English Bay/Sunset Beach as well as Stanley Park. Hornby Street has great bike lanes if you want to rent from the shop nearby (Cycle City) and ride around the city.
Cam's room is in a hotel, and it's clean and has the amenities you need to use the kitchenette. It has a really nice king bed, blackout shades, and good AC (which is a little noisy, but didn't keep us up). I'd look for his place again next time I'm in town.