I'm a professional bike mechanic/ sales guy. A human powered transportation specialist if you will.
You can ride almost any bike anywhere. If you have lots of off road riding experience you will have the skill to get through hard parts and you will have the sense to get off and push when it's necessary. If you don't have the skill to ride rough terrain you will push any bike you buy anyway. (may as well find a light walking stick.)
Bikes are like vehicles, each one has a specific purpose. the "commuter" is a 4door hatch back, very practical,zippy, easy to park in the city good for city streets and the occasional short cut/ gravel road. The "comfort" bike is a mini van..practical, comfortable, good on gas yet inspires no passion in driving. The Mountain bike is an Off Road/ SUV type vehicle. No one buys a 4x4 for its fuel efficiency. great off road but suffers "slowness" on pavement, hard on gas. uncomfortable on long flat stretches. It is geared for low end torque not top end speed. The Duel sport bike lives between the the Hybrid/commuter bike and the 29 inch wheeled mountain bike (think Subaru forester). The Road bike is an Italian Super car. Very fast on smooth pavement only. The cycle cross bike is a Rally race car. It goes as fast as a Lamborghini but you can drive on a gravel road.
There is no Unicorn. AKA...a 4x4 vehicle that fits 8 people goes 0-60 in 4seconds and gets 65mpg.
you will have to pick your compromises.
Regardless of the brand a bike, It has to fit you 3 ways.... your intended purpose (where will you be riding this bike 70% of the time)
It has to fit your body...if its a size to big or small you will be uncomfortable and you will not ride your bike. It will live in the garage until you sell it to some other guy.
It has to fit your budget.
One brand is as good as another as long as you are comparing price points and intended use. each brand will ride differently and interact with your body differently. Think jeans..two brands of the same sizing WILL fit differently. Pick the one you feel most comfortable and confident on.
when all these thing align you will have a bike that will be used and enjoyed for years. (with proper maintenance)
most importantly buy a bike from an independent retailer who gives you the best customer service.
I'd say come see me in canada but it might be a long drive.