I love apples and eat all sorts, being here in Washington state we have a lot of options. I've tried the new Cosmic Crisp, I really like it but will have to wait until more trees come into production/prices go down. I think it will be a great addition to juices eventually.
I do like the Honey Crisp, they are best fresh and don't store over the year well in my opinion.
Opal is my usual choice for an eating apple right now if they are in stock. Yellow and rather pointy, sweet lightened with just a bit of tartness. Crisp and juicy and they don't turn brown fast, since I'm only allowed half an apple a day I notice that.