My advice, as someone who grew up regularly apple-picking, for going local is to prefer the types that are local versus the names that you recognize from the supermarket. Unless you are in exactly the right area (upper Midwest), you will be much better off with the best apples for your region then with a locally grown Honeycrisp.

In upstate New York, I would recommend Autumn Crisp, Blondee, Macoun and Shizuka. I haven't picked apples in Virginia in about a decade, so I'm probably out of date on the right types to get there, but I remember loving Stayman apples.