I'm on my second Forester now, a new-at-purchase 2008 model (my first-ever brand new car). Prior to that I had a 98. Decent cargo capacity especially with the rear seats down, seats 4-5 (though the 2-3 in back should not be overly large) with them up, good power in stock edition so you're right that the additional 50hp for the turbo model ought to be quite fun. Decent standard off-road capability, excellent in upstate-NY-style winter weather. I don't get great mileage, though I could do better if I'd drive less like I did when I owned a 5.0L Mustang. I probably wouldn't have had to have spent $1100 on brakes and rotors last month, either... Standard trans would get about 2mpg better than the 24 or so I get combined city/highway (upwards of 28 straight highway, but I don't do that much lately). I had to have auto, because Lori cannot and more importantly WILL not drive a stick shift.
Once I get my mid-life-crisis-mobile (another Mustang, of course), that means it'll be ALL MINE!!! Mua-HAHAHAHAHA!!!!
>Ahem< Sorry about that.
If you can deal with a max of ~30mpg highway, I'd have no problem recommending Subaru in general and a Forester in particular.