Why anyone living in Vancouver would away their money on an Accord I'll never know.
I live in Vancouver and I do drive a car but not an Accord. However, anyone who wants to buy an Accord is free to do so. They sell quite well. 22,012 were sold in Canada in 2007, making it #9 in sales. The Accord has always been the top 5 in the USA.
That said, public transportation in Vancouver is good as long as you live along the major routes.