There's so many, and they're hard to keep track of. Winesap's my favorite, but you can only get them in the fall. Honeycrisp, pink lady, and jazz are pretty reliable. Macintosh is decent, but nothing exciting. I used to really like GrannySmith, but I burned out on them. They aren't that good compared to the new styles, but they're a million times better than the ~early 90s standards.
What I need to do is get all the ones Wegmans sells, and takes notes on them. There's some widely sold varieties I like, but they look similar to varieties that are pretty meh, so I'm afraid to get a whole bag thinking I might be remembering wrong.
In any case, stay far away from red delicious. They're one of the prettiest apples; picture perfect, but the trade off is terrible flavor.
https://en.wikipedia.org/wiki/Red_Delicious