We stayed at the Granville Island Hotel on our trip to Vancouver and I think it was the best place to stay. It was central to pretty much everything we wanted to see and the market is the absolute best! We spent more time on the island than we originally expected just because it was so pleasant and there were plenty of great restaurants to check out.