I’m surprised I didn’t come across this video earlier.  The video is from May 2009 and is a time-lapse (albeit in reverse) of a run along the Canada Line from Waterfront Station all the way to the airport.   The video actually stops short of YVR station, which is a shame.  However, it gives you an idea of how the line will feel like if you were riding at the front of the train.