The situation in Colorado is analogous to The Netherlands explicitly declaring something allowed that the EU councils in Brussels have explicitly declared disallowed. One authority claims it's OK, the other claims it's not OK, and the citizen has to choose which authority they trust and/or fear more.
EU law binds countries, not people. If a country does something that goes against EU law (which happens all the freaking time), then you can sue the country in the EU courts to get the country to change the law. The EU isn't able to arrest you. And regardless, it's the national law is the only real law. EU law is just what a country is supposed to do.
[1] There is Europol (European Police Office) which is only for aiding cooperation between national police forces. It has no powers of arrest, and (most tellingly) it only has 800 staff for a population of half a billion people.
I believe it's evident that when you fly a bunch of groups under a single banner successfully for a long time, what starts as a loose, powerless alliance with only administrative activities (as the US was originally conceived) eventually becomes a very strong central power apparatus (as the US has now become).
Maybe it'll be different in Europe where the member states have so much independent history. Everything out here was basically a blank slate before it was annexed by the Union. In the relatively few places where this isn't true, there is much stronger anti-federal sentiment (the South, Hawaii). I guess New England is anomalous regarding anti-federal sentiments because I think it has always thought of itself as the most influential power in federal governance.
The result of this is that while you can be doing something for which you cannot be charged by the state, the Federal government has the ability to prosecute you at their discretion. This is where the risk comes in; you are at the mercy of the federal government to continue deciding that they won't enforce the federal laws in those states.
Only two (or three, depending on how you view the legal status in Alaska) have laws that actually create a legal framework surrounding it (ie, "legalized it").
The situation in the Netherlands is more complicated. Technically it's still illegal, however it's effectively decriminalised for personal use. Small amounts found on you (less than 5 grams) will not be prosecuted. No more than 5 grams may be sold to one person in one transaction. You must be over 18. 'Coffee shops' should not cause any trouble, drugs may not be advertised and the mayor can order a 'coffee shop' to be shut down.
More recently (2012) these coffee shops have also been ordered to close their doors to foreigners, and there's a proposal to classify very potent (over 15% TCH) marijuana as hard drugs.
Things keep changing so who knows what will happen in the next few years.
And I don't think there is any EU law on illegal drugs like that.
You're correct that ultimately marijuana will probably be really cheap, but we have to wait for the rest of the drug enforcement apparatus to become irrelevant.