The scheme I described above leads to affordable tickets, it's basically a way of enforcing nontransferability.
But at its core, disgust with scalpers implies preference for a non Kaldor Hicks optimal world.
If someone is willing to pay $X for a ticket, and you're only willing to pay $Y<$X, it is non optimal for you to get a ticket if you'd sell your ticket for less than $X.
There's no way around that fundamental fact. At some point, if there are more people who want tickets than tickets, some process needs to determine who gets them, and wishful thinking doesn't help anyone.