Definitely, the best case for cars is to have fast highways that bypass the city, but there isn't a lot of room with that given Vancouver's geography, so it's a lesser-of-two-evils. Beyond cars, public transit and cycling provide a better solution in my opinion anyway.
Regardless... the biggest traffic pain point in downtown Vancouver is the 3-lane (total) Lions Gate bridge.