If you can get the stick, get the Forester in stick. Subaru's only other transmission option these days is a CVT, and I still don't trust the longevity and repairability of these. For instance, the owner's manual states that the CVT transmission module, or whatever the heck they call it, cannot be serviced and does not require maintenance. Then page over to the maintenance section at the end of the manual and it demands that if you tow, drive in excessively hot or cold climates, or in dusty environments you will need to service and maintain the CVT "sooner" than the previously specified service schedule. Which is never, because it just said it can't be repaired or serviced. Needless to say, this skeeves me out. I can at least wrench on a manual transmission myself, and it has the bonus side effect of preventing people from asking to borrow my car.
Me personally, I would avoid all Mazda products unless you specifically want a Miata as a project/track car. Everyone I've known with a recent Mazda has wound up with a pile of issues. Somehow their Ford lineage is still managing to show through. A Scoob will be much easier to work on yourself in my opinion, if that matters to you.
Full disclosure: Mine is a Subaru family. I own a manual Crosstrek after having previously owned a Manual Impreza. My wife has a new CVT Impreza so we'll see how that goes, my father has an Outback, and my stepmother has a Forester. Dad's Outback has the CVT and stepmom's Forester is old enough (I believe the last model year) that it still has a conventional slushbox. No major issues with any of them over a couple of decades, and my folks are definitely completely lackadaisical in the vehicle service department. The newer FB engines in all of our cars except the old Forester are even chain timed, so that removes one major maintenance hassle right from the jump.
It occurs to me that my Crosstrek turned 10 years old last year. I've been beating the shit out of it this whole time, using it as an off-road camping toy and general purpose hauling tool. It's been driven across the country twice. The paint ultimately got so beat up I recoated the entire thing in truck bed liner. I should have got it a cake.