Taking photo on bridge has to deal with vibration. I believe it's okay for Burrard where local traffic is light... Last time when I'm on Second Narrow trying shooting the sunset, it's shaking like hell...
I used to park on Vancouver side. However, if you are alone, it may not be that good as there are many blind spots with no streetlighting for the pedestrian sidewalk.