Yes, the people I met were all really very friendly. Most of downtown looks so nice and clean and colorful. But there are also neighbourhoods which are not so nice. I had my hotel in the worst and most dangerous location of Vancouver because I booked the cheapest offer I could find. I saw lot of homeless people and drug addicts there. I was asked for money or they wanted to sell drugs but I did not have a serious problem with them. One of them asked for my pizza I was carrying, so I gave it to him...
But compared to big cities in the USA Vancouver is totally save, I think.