I have an 87 Civic hatchback 5-speed with the (preferred)larger 1.5 liter engine and get high 30's to 40 mpg. With a short wheelbase, fwd and engine over the front wheels, the snow traction is pretty good. I use studded snow tires on front when I know snow will be encountered. The car is so light that just one buddy is usually enough to push it out of a problem. With one rear seat folded down, three climbers and all their gear, for whatever, will fit.
The two main problems for me are going up to Paradise in the winter (a lot) and the south route road into Mt. Adams. Chains are a pain. The way out of it is to trade off with your 4-wheel buddies for the hard stuff, but then you are on their schedule not yours. I am very curious about the existence of a lift kit for a civic. That seems pretty doubtful though.
The Civic works great, but with a Subaru you wouldn't have to compromise. If you are a Microsofty wait for the new Volkswagon Touraq(?) that's coming out next year, it is the final solution, but costly.