As far as power goes - I drove it loaded with camping gear up Route 487 in Northeast Pennsylvania (near Rickett's Glen.) If you've ever been there, you know what kind of hill it is. Insane. It was great. Then again, so was my 2008 Fit with 109 HP. Yes, I had to downshift. Oh the humanity. But they are quick (as opposed to outright fast). Of course, you should get the 155HP 2.0 Manual for best fuel mileage - if you get a 2014+ auto, you'll get the 185HP 2.5 which actually gets nearly the same gas mileage... but AWD will definitely reduce it. The gears are low enough that you can have fun, but that's not why you're considering it.
One major advantage is the suspension. It's rated for 1000 lb payload. The 2008 Fit is pretty awful. I load it often, but it hurts from it... the back sags down. Just 8 bags of mulch was enough to put a serious hurt on it. The CX-5 wouldn't flinch at that sort of load. So if you do a lot of DIY that might involve bringing heavy things home in your car, keep that in mind. I don't mind moving small furniture and odds and ends in the Fit - even a king sized Ikea bed frame and rolled up foam mattress were great fits. But heavier stuff and bigger furniture is a no go. With the CX-5, I managed to move a love seat (2 cushion) and sofa (3 cushion) which was pretty neat. Of course, it was hanging out the back with the hatch up, but for a short trip, and $50 for the set... it was worth it!