Honeycrisp are amazing. So are Jazz, if you can find them. Our local grocer has many interesting kinds. Also, read Michael Pollan's "The Botany of Desire" for a more in-depth treatment of apple biodiversity vs. the market forces.
They are great apples, but they're also about 3x as expensive as Red Delicious apples (at least where I am in the US).
You'd have to pay me to eat a Red Delicious if Honeycrisp is in season.
They are really hard to find... almost as if they are seasonal or something!