I just got my medical after ONE YEAR of jumping through the FAA's hoops.
I got a DUI in 2007 and applied for my medical in March 2011. That DUI is the ONLY thing on my record BTW and it still took a year.
The reason it took so long is because I blew a .22 and the FAA's cut off at the time for tollerance and dependency issue was .20. They have recently reaised that to a .25
If you are worried about getting a job, I wouldn't be. Maybe you wont fly with an airline immediatly but there are so many locally owned flying jobs out there owned by guys that have recieved DUI's and worse. Shoot Ive heard of a few Ag pilots that dont even have drivers liscences.
Appeal their revocation and as long as you have professional evidence that says you dont have a dependency issue I dont see why you would not get your medical back. It might take some time but it is worth it.
I bought an airplane right before I applied and this last year has been the longest in my life but I recieved my 3rd class (not a special issuance!!!) med and SPC in the mail a few days ago.
DONT GIVE UP ON YOUR DREAM!!