When I was a kid, I only remember ever eating one kind of apple, the Red Delicious (I think grocery stores also regularly carried Granny Smith as a cooking apple, and a few may have carried Golden Delicious just for pizazz). Ironically, in our taste test, Red Delicious didn't rank too high. Tough skin, flavorless, medium crisp--nothing about it was thrilling. But commercial growers and grocers love them! Why? The thick skin ships well over long distances, the shiny red exterior is attractive, and, well, it's not like you're going to taste test it in the store...so flavor is irrelevant, especially if you don't even carry an eating apple alternative.
At least, until the stores starting carrying a wider variety of apples. Ever notice how during Honeycrisp season, people are willing to pay 3 or 4x as much for an apple that actually has flavor. Go figure!
If you want a real treat, expand your horizons and go apple picking in a local orchard. Not only will you have a fresher product, but the variety is wonderful. Even better is if you can get your hands on an heirloom variety.
Below is a list of a few local picking farms that you and your family might enjoy, although I've heard that crops are down this year, so make sure to check what is available before you pack up the family van:
All Seasons Orchard