Did you find this post I made recently? It lists all of the apples I tried, many unusual ones:
Scott's Apple Experiences Through 2022
Off the top of my head, Abbondanza, Hunge, Wickson, and Black Limbertwig are a few more which are pretty unique.
I eventually removed Zestar! due to the rotting. It is too bad, when it was good it was super awesome.
You have the right idea on aging, to get the best flavor on most varieties you need to pick late (but not too late!), and age well. I try to take varieties to over-ripe on the tree and mealy out of storage so I know what too far is … for many apples I was nowhere near the right spot for too long, only when you overdo it can the sweet spot be known for sure.