There are of course major examples of unilateral actions on the part of the US to be sure, but those are outliers albeit extreme ones.
As is the case with most things related to the UN as it applies to the US, the US can ignore it tomorrow morning, and there is absolutely nothing that will or can realistically be done about it. Who is going to do what, exactly? The US is by far the prime leader in the war on drugs, if we fold our cards, it's instantly game over, no matter what half-cocked treaties are outstanding.
Enforcement is purely optional at this point already, as has already been demonstrated in Washington and Colorado, and a lot more are going to follow.
Hence my previous statement:
There is always the unilateral option but the US wouldn't do that in this case because it would open the gates for every other country and the political interests are way too strong.
What political interests? Most European elites are begging for the US to come around so that they can have the political cover to drop this madness. They cannot do that until World Police changes its stance, because they'd be commercially blacklisted into the Middle Age.
The political interests were there when the US could use drug policy to support this or that puppet government in Latin America or Afghanistan. This strategy has failed so thoroughly in the long run, your own backyard is now giving up and leading decriminalisation. The US government would get a lot of goodwill around the world by ending the prohibition idiocy.
Portugal was blacklisted to the middle ages? Eventually Europeans will have to stop pretending everything is the US's fault and be responsible for their own countries.
We see this in the response to copyright infringement too e.g. ACTA - the executive thinks this is a thing that needs doing, but will never get past elected representatives because the public doesn't like it.
A lot of the hostility towards Europe stems from it's constituent governments using it like this.
Is this a reaction to a flaw in democracy?
This is the major distinction between Cannabis prohibition and Alcohol prohibition. The latter could be turned off by the US government, the former requires snubbing the UN. There is always the unilateral option but the US wouldn't do that in this case because it would open the gates for every other country and the political interests are way too strong.
Basically for the US to formally "legalize it" the rest of the world would have to as well, which is why Argentina and Uruguay are great examples of leadership when it comes to the Drug war; they are both UN members and implied signatories to the treaty.
[1]http://en.wikipedia.org/wiki/Single_Convention_on_Narcotic_D...