The skytrain will take you from the YVR arrivals terminal right downtown. Cost is 6 bucks, and you will be at your apartment or hotel in 20-30 minutes.
The city is most the most walkable in the world, with almost no need for a car (unless you really like to go on weekend road trips). Crime is extremely low right now, and the city economy is very solid.
With TED moving to the city next year (and a bunch of other things falling into place), it is a great time to move to Vancouver to find a job or start a business.
Also, the thing about french is not true in the west. No one speaks a lick of french anywhere west of Ontario, and it will never be a job requirement, unless you are applying to work with the federal government.