My preferred apple is Mutsu, available from a few growers in the late season at my southern Ontario farmers market. According to Wikipedia it's been around since 1949, but perhaps it simply never got popular enough to face these pressures— either way, I find it consistently to be in the right place for me as far as a balance of sweet, tangy, and crispy.