My own experience is that Honeycrisp is the most consistently sweet and crisp apple you can buy (contrary to the claims made in TFA -- maybe it's a regional thing?). Cosmic Crisp is decent but I'm not a fan of the flavor.
It's likely that the best apple will be whatever of the "honeycrisp-like" varieties you can acquire on with the shortest time between tree and your mouth.