Of all the bountiful speculation in this thread, much of which is certainly within the realm of possibility... you may be on to something with the bipolar thing.
That fits.
He has clearly shown the delusions of grandeur thing, RDA press conference, "God's are cool with other gods" that could be his manic phase coming out.
If you fancy yourself the coolest cat on the planet and then your body starts crashing when you need to show out... yeah, maybe you hit the nose candy for a little extra pick me up.
That makes sense.
My eldest son has ADHD w/ODD (was initially my first thought about Conor given his energy level even when sober), and believe me, I see striking similarities there, particularly with the Oppositional Defiance Disorder comorbidity. It normally presents early in life, but depending on the family life, it may never even get noticed or treated. It's incredibly difficult to deal with, it is usually violent, and it can destroy families, both physically and mentally. ODD can also pair with Bipolar Disorder and Anxiety disorders. Drug abuse makes it far more difficult to pinpoint.
A single mother or father, trying to raise a child with this disorder (ODD), in today's snowflake world... would get my deepest sympathies.
Conor has more money than most of us will ever earn in our entire lives, even if we lived several. Cocaine is an expensive habit for those who have average wages, it's nothing to him. I am sure he buys in bulk, and probably gets free candy supplied everywhere he goes from others just for the interaction/hang out time. What kind of cokehead is going to turn down free cocaine? His problem will be forever chasing the high to avoid any real life symptoms of any disorders, and usually leads to trying to find the better high.
Honestly... the women, alcohol, jet-setting and bar tabs will drain the bank account much, much faster than the cocaine will.
Any possible mental disorders or not, Conor's on a path either to jail or to an early grave if he keeps walking down this road. Dude is out of control in a way that even makes Jones look like a saint.