But if you're not a paid pilot, you're better off not going down that route, since once you're on record as having a deficiency, that's a permanent concern to the FAA. And if they decline the special issuance, you're also not eligible for the drivers license medical.
I would advise nobody with issues who wants to fly for hobby reasons to go down the PPL route since you can get banned for failng a medical. There's almost no upside and huge downside to risking that.
I did witness an AME re-approve a commercial guy with a DUI though while in the waiting room. Good on you, FAA.
Thanks for the DUI anecdote. Great that he got re-approved, but that can be retracted anytime.
Just to recap - the FAA assumes if you get an airman medical, you might try to carry passengers, so their medical rules are maximally strict.