MikeC → This link discusses leaving Goldrush on the tree even down to the mid to low 20’s. Do I need to pick GoldRush apples before 27 degree night? - #13 by Matt_in_Maryland . An orchard near me (Youngstown) seems to have good Goldrushes every year and we are a little colder than you are.
I’ve got a few Ashmead’s from my young tree and they were fantastic. I ordered another tree this year.
Here is a link ( https://rittmanorchards.com/apple-chart ) to an orchard in Akron, OH that has good descriptions and appx ripening dates for a list of apples they grow, including some Russets. Several are listed as sweet/tart. The better ones seem to be later varieties. Anything grown in NE Ohio should do as well or better where you’re at. I’ve tried Esopus Spitzenburg and Melrose from that orchard and they were both very good sweet-tart apples. Melrose is supposedly very easy to grow.
Edit → I just realized that if you click on any of the apples in the above list, you get a little more detailed description and many have a picture of the apple variety that appears to be taken at their orchard.