My favorite description of a Red Delicious apple was from Mitsuwa (japanese grocery store in the US): "Looks nice, flavorless. Ok in salads"

Growing up, I really liked Winesaps from a local orchard, but those were rated "Horse Food" on this list. To each their own, I guess.