Granny Smith is a baking apple. I don't know anyone who eats it raw. It's great for pies and crumbles and apple crisp.
Edit: in fact, I just picked one out of the fruit bowl. Yes, it's not the sweetest apple in the world, but not everything has to be. And the crunch of biting into it is good.
Better second-tier mainstream apples here are Macintosh and Golden Delicious, before you start getting to the premium apples like Gala, Fuji, and the varieties people are loving on in this thread.
Edit: typo
Even with an abundance of options today, I still enjoy them on occasion.
To each their own ;-)