It's sad that the apple we all grew up with isn't even on your list.
Red Delicious.
It's a great apple, but only when picked ripe from the tree. They don't keep well, so they are either picked early when they're still green inside, or they get dry and mushy.