I really enjoyed staying at Michelle's place for three nights. The neighborhood is very local, and walking distance to lots of Asian restaurants and bubble tea cafes (my favorite was Dumpling House). The sky train is a 15 minute walk via residential streets followed by a 15 minute train ride to downtown and waterfront.
The place itself has a great view from the shared patio. I'd especially recommend staying here if you're looking to do any laptop work, as the private room has a nice desk in front of a window with a pleasant view of the neighborhood. It was nice to be able to freely use the kitchen, though I only used it for simple breakfasts.
Michelle is really friendly and is great with local advice on things to do in Vancouver. She told me about a festival that I went to and wouldn't have known about without her.