This falls into the 'pointless waste of dev resources' category for me. Now this is all my opinion, but I would prefer that they work on combat, skills, weapons, armour, enemies, heroic quests, bug detection before they start including relationships, farming, families, and yes, intoxication. Have the screen go blurry, have my character pass out, fine. Don't make it a big deal. GTA4 had a great drunk mode - it was annoying and you got nothing accomplished and you just had to wait it out. The only new intoxication thing I would appreciate is being able to buy someone a beer to loosen their tongue when trying to get information. Of course, if Oblivion is anything to judge by, we won't have to worry much about talking in Skyrim...
/end rant/