We're local (1 hour east of Vancouver) and just stayed at the Coast Coal Harbour last week. It was a great location, maybe a five minute walk from the terminal, nice room, we had a corner room with floor to ceiling windows and great views, but the biggest plus was the service! Wonderful, friendly staff, so nice and helpful. I had joined my husband at the last minute on a business trip when his associate couldn't come along, so they weren't expecting him to arrive with 2 toddlers in tow. They were so quick to bring up a crib, help us with finding kid friendly restaurants nearby and even brought milk and warm cookies up to the room for them at no charge!
We love doing quick trips into the city and have stayed at a lot of places that are great (Sutton Place, Pan Pacific, Fairmont Hotel Vancouver, L'Hermitage) but for a balance of reasonable price, great location and amazing service, Coast Coal Harbour has moved to the top of our list.