The study also name Spie apples, an old (and vanishing) variety that is superb for pies. I wonder if they studied the old-fashioned Transparent apple. Sure, they're hard to pick [joke] but they make the best applesauce there is. Commercially they pose a problem because they bear heavily every other year, and have a much lighter yield the others.
I buy Fuji and Royal Gala, a few Golden Delicious.
When I lived in Mossyrock Washington my neighbor had a Chehalis apple tree in his orchard. Those grew huge and were yummy to eat fresh off of the tree or bake into a pie. Perfect texture and sweetness and tartness .... Nothing like
them in the stores.