I agree with you on that. Vancouver isn't really a fun city, it is a city where you have to work hard everyday to pay the high taxes and rents. It has a lot of amenities which is its strong suit but it doesn't have a lot of events or festivals where people could gather around and have fun. The other problem might be that it is too multicultural where it seems that the population is fragmented. People of different cultures and customs have different ways of interacting with others and this is probably what has created the reputation of Vancouver being less of a friendly city. I find that travelling to less multicultural cities like Manila where the population is more homogeneous, that the people are more closer and friendlier versus multicultural cities like New York, Toronto or Vancouver.
There are multicultural cities that are friendly, L.A. and Montreal come to mind, Vancouver just has the wrong cultures and subcultures.
Going a bit deeper than the unfriendliness factor though, is that Vancouver has by far the highest percentage of underhanded and creepy people I've seen anywhere, whereever you go you'll always find some toxic losers but they seem to be attracted to and thrive in this environment.