I had a Forester years ago. Bought it brand new (ordered it, actually). It was a 1999, 5 speed. I drove it until 2005, putting about 170,000 miles on it before trading it. No major issues. Really, pretty much routine maintenance and new tires. Near the end it started to get a bit of oil leakage, and I have heard that is not uncommon among Subarus. But, it was all wheel drive, and the gas mileage sounds like it was about the same as the CR-V's (from what I see posted here). I averaged around 24 mpg. Mostly in town driving.
It was extremely reliable and easy to maneuver. Good visibility. I'd own one again if it were just me in the car all the time. We moved up to something with more cabin space because with 4 of us (and the kids growing) it was getting kinda crampy on family vacations.
I have heard good things about the CR-V's, too, but I have not personally owned nor driven one. I have owned a couple of honda's, and they were good cars, but that was YEAAAARS ago.... before they even made CR-Vs, lol.
If AWD would be an asset to you where you live, then I think a Forester could be a good option.