Pippins! Or are they called something else in other regions?
Green with a blush, crisp, pretty tart. Good for pies or out-of-hand both.
Granny Smiths are the Red Delicious of green apples by the time they reach my palate.
Russets are apple royalty as far as I’m concerned.
Cox’s Orange Pippins are the aristocracy.
Braeburns and Galas are very acceptable.
I won’t touch Golden delicious - they’re vaguely apple flavoured mush that’s been reformed into an apple shape. Red delicious and Macintosh aren’t much better for texture but taste a bit better.
Fuji and Empire (and maybe Gala?) are probably my favourites. I don’t really get the love for Honeycrisp, personally.
I don’t mind Red and Golden Delicious, as long as they’re fresh and crisp.
Honeycrisp. Accept no substitutes.
Winesap. Even if they tasted like dirt the name alone would make these tasty.
Empire and Granny Smith.
My all-time favorite apples are Jonathan. I know a lot of people think they’re just for cooking, but I like to eat them “out-of-hand”.
Ashmead’s Kernel (a gold/flushed russet with an almost pear-like aroma). I don’t really like overly crisp apples - I find them generally lacking in flavour - a good apple at the proper stage of natural ripeness can be softly crunchy and juicy, without being wooly or pithy.
I’m partial to Fujis and Galas; just enough tartness for me. I like them sweet.
Honeycrisp is a new favorite for me. I’m also partial to Jonagold and Pink Lady.
Asian Apple Pears.
Macoun, Jazz, Honeycrisp, Granny Smith, Fuji, pretty much in that order.
Northern Spy, Winesap, Both great for eating, pies, apple sauce and cider! Every year on a cool, crisp, sunny October day, my family grinds & presses several bushels. Still have about a quarter of a bushel of spys left for eating, pies, & apple sauce.
This is apple and pear country (among other things), so we get them picked ripe off the trees. Honeycrisp is our fave this year.
I was lucky enough to find an orchard selling King David apples this summer- the best eating apple ever. They taste about like apple Jolly Ranchers. I also bought a large bag of Grimes Goldens, a yellow apple whose flavor makes one wonder why anyone would eat a Golden Delicious.
I also really like Winesaps and Yellow Transparents or Lodis as long as they’re not over ripe. Cortlands are outstanding if picked half-red- they get too soft if left on the tree too long.
All apples are much better if purchased from an orchard and not from a grocery store. Even Red Delicious are good when you get them from an orchard, unlike the ones from a grocery store.
This is not true. Fresh red delicious taste of something other than cardboard but they aren’t “good.” I got fresh picked red delicious from my farm share. They traveled less than 40 miles to get to me and had been picked the day before. The were bland as hell. I made them into apple sauce and pretended I’d never received such an abomination.
Agree with Annie Xmas that Asian pears are lovely but despite their globular shape, they aren’t apples. 
Albemarle Pippins.
Runnerup: Black Twig
My favorite up until recently was the Gala, or Royal Gala, until a month or two ago, when I tried Spartan. In my mind, it’s like a happy medium between the crisp tartness of a Mac and the sweetness of the Royal Gala. I really enjoyed it.
Interesting replies. Needless to say, I’ve never heard of many of these varieties. I wish there were an orchard around.
Empire, Cortland, Fuji, Braeburn and when all else fails, McIntosh.