Hey guys, a lurker here who doesn't post normally. But now yes, Moody is absolutely not something we want to see in ubers. I just swept a team with mono-attacking Bibarel, in the sun. My team has not been put a lot of thought in and I should just have been 6-0ed by Darkrai right off the bat. Just watch the first 10 turns of this battle, after that it's already over.
http://www.pokemonshowdown.com/replay/uberssuspecttest-14456134
This is of course an outrageous battle. But still, I disagree with the general opinion in this thread that Moody is ineffective, extremely unreliable, or just outright bad. The thing is, it IS unreliable if you play it wrong. But if you play it well and support it well, you can be sure to have success with it. Yes, occasionally you need Moody's speed boost, but most of the time you can make setting up easy with help from the aforementioned Wobbuffet and SubBP Gliscor, or whatever you want to use that can give you a free turn. Or you just come in with your Glalie/Bibarel (Octillery and Smeargle are too slow for it, haven't tested them out anyways) on their base 90 speed pokemon and just start spamming sub and protect. Taunt the Roar and Perish Song users while behind a sub (when you aren't, prediction....but most of the time, you are) and when you get to +4 everything, start knocking your opponents team over.
Once you get a few evasion boosts and your opponent lacks a move that always hits, it's gg. Do watch out for the occasional Roar or Perish Song, but Taunt does take care of this. Even if they do have a move that always hits, it's game over most of the time, because you can outstall it or just bombard the pokemon trying to stop you with +4 attacks. Note that a lot of Thunders in ubers cannot break Glalie's sub at +3 or above SpDef.
So guys, what I am trying to say is that Moody does require a little bit of skill (the battle was just a joke, most of them do not go like that), it is really really broken and bad for the ubers metagame, by making matches WAAAY longer than they need to be. Even if you run specific movesets/pokes to stop moody, once they get their sub up, you cannot do too much. I do not understand why people don't use Moody more on the ladder, I have not got the reqs yet (come on look at my team, too lazy to make an actual good one, maybe I'll steal Melee Mewtwo's, whose team already inspired mine) but I have won a surprisingly big amount of games against good players. Sometimes by luck, but more times just by the sheer power of Moody.