I've worked with plenty of varieties in the kitchen ... they can make your juice far too sour if used on their own. Granny Smith apples are tart, and without a sweeter apple to balance them ...
Paul Locher explains how valuable apples were on the frontier of Ohio Country in the early 1800s, and how settlers improved ...
If you're a cider lover, you might find that sour beers are a great drink of choice. These sours in particular have the same tart, fruity flavors as cider.