Yes. It should be up to the States and local communities to deal with substances that tend to alter behavior. Ultimately, we should all be judged by our behavior. We are a far cry from that these days.
You're right. Ultimately, it's the only thing we are "judged" by -- in any case, our behavior, making each our individual ways through life's temptations, determines our destiny for the most part and what government thinks/judges of that moral behavior is an afterthought.
One FReeper (not me) stated it pretty well sometime back in a post somewhere -- that the worst is when "social conservative" means confusing sin with crime, using government to punish (as opposed to liberals using government to nourish) sin. The truth is that government, at least Federal government has zero role in it at all. Conservative Christians should know that and respect it!