It is pointless and counter-productive to aim to fly a certain type or aircraft. We all had our favorites of course when we were kids, but you cannot plan your career around a specific aircraft type (unless you're military).

The typical path in the US (Canada is similar):
CPL w/ IR
Instructor ratings
Work as CFI to 1000 or 1500 hours.
Fly small freight/charter planes to 1500 hours (optional now)
Fly regional jets as an FO for 2-4 years.
Regional jet CA for 2-10 years
Major airline.

At the major you'll fly what your seniority dictates, usually domestic (north america) narrow-bodies. More senior pilots do most of the wide-body/international flying.

If you really want to fly widebodies over-water, that will limit your major airline options. SWA and Westjet for example only fly narrow-bodies in North America.

As a Canadian, your best career progression will probably be at a US airline. You'll need right-to-work here, but could actually live in Canada and commute to work in the US if you wanted to.