My team's admin used to buy apples for us, including some Red Delicious. I explained that they were terrible so she stopped. It was easy to find supporting evidence in the form of 5 articles with titles like "Red Delicious is the worst apple in the world." No reason to buy them, except that they look pretty.
Recently there have been lots of new varieties, mostly distinguished by their good flavor and texture. Honey Crisp, as you mentioned, is one example. Cosmic Crisp is another: first available in 2019?, developed and grown in Washington state. Not sure if it's available in other states yet.