I’ve had plenty of experience with non-supermarket fresh apples straight from the local orchard. I live in Virginia and actually used to buy produce for a small store that specialized in “local.”
Apples I liked: Albemarle Pippin, Smokehouse, Black Twig, Mutzu, Spitzenberg, Gala, Fuji, Jonagold, Stayman, Ginger Gold, Virginia Gold, (and a very small sweet old-time variety whose name escapes me but had the sweetest taste of any apple I ever had).
Apples that were just OK: Idared, MacIntosh, Jonathan, Cortland, Prima, Granny Smith, Gold Delicious, Red Delicious
Apples fit for horses only: Rambo, Lodi, York
See…lots of apples eaten over my 51 years of existence, some quite good* for an apple*. Thing is, they were all still apples and just not the sort of thing I’d get to excited about compared to other fruits.
However, I’ve tasted melons of amazing flavor, the sweetest of seeded grapes, golden raspberries that make your head swim they are so good, plums of the highest order, peaches that light up the universe with a bite etc. etc.
The best of the other fruits easily trump the best of the apples. All us apple critics are saying is that apples are quite overrated given their space in our lives compared with other fruits.