I see lots that I haven't heard of, and several that are tasty to my palate as well.
I started a little "orchard" about 5 years ago and although it's mostly decoration, I'm trimming and doing what I can to get them all to be producers. 4 of my trees are apple. One each of Arkansas Black, Fuji, Macintosh, & Granny Smith.
I used to like plain old red apples as a kid but they became tasteless to me - of course they're all via mega-store chains so not really fair on determining good quality flavor. I should travel to some of the orchards in AR and see what I can find.
As far as the sugar, it's not all "equal". Sugar from fruit comes with it's own "mop" of insoluble fiber and has different effects on the body than what most people should worry about in their total (processed) sugar consumption.