The problem with weather is that NOTHING that is not weather is anywhere near the same magnitude as Drizzle (and Drought) as team support.
Hazards? Residual damage on switches; can be spun away, Magic Bounced/Coated, Taunted; requires a turn (or more) to set up; requires a moveslot.
Now hazards are very useful, and are metagame defining. They keep power houseslike Volcorona in check, and Stealth Rock weakness is one of the biggest determining factors in a Pokemon's viability. They also support sweepers by weakening walls, and are almost essential to a stall team. But there are plently of ways of circumventing hazards. Rapid Spin is viable solely for its ability to remove hazards, and Magic Bounce users are seen in OU for the same reason. Taunt is also usable in a pinch, as all hazards are non-attacking moves. Hazards also take time to set up. Stealth Rock only takes one turn, but Spikes and Toxic Spikes take multiple turns of setup for the full effect. Hazards also use a moveslot, which might be used for another utility or attacking move.
Dual Screens? Half damage for 8 turns; can be taunted, stalled out; requires 2 turns , 2 moveslots, and typically an item.
Dual screens are also useful. The halved damage can give frail setup sweepers a chance to shine, or allow Pokemon with a vulnerability to priority or scarfers an opportunity to sweep. There are substantial flaws though. Taunt can completely ruin Dual Screens, and opposing Pokemon can sett up alongside the Screen user. There is also a significant investment needed for the strategy to bear fruit. Two turns are needed to set up both Screens, and a turn must be spent either suiciding or switching to a sweeper. The item Light Clay is almost required for the Dual Screener, but there are still only about five turns of Screens available to the sweeper, which can be stalled out with clever switching or use of Protect. The Dual Screener is also commited to the strategy, with little outside utility.
(Space to answer other forms of team support)
Drizzle? Boosts Water-type moves, that have good neutral coverage, by 50%; reduces Fire-type moves by 50%, buffing the already defensively great Steel type; fixes Thunder's and Hurricane's accuracy; gives free healing to Pokemon with certain Abilities, like Dry Skin and Rain Dish; gives Pokemon with Hydration practical immunity to status; activates Swift Swim (which we banned); lasts entire battle, cannot be removed except with weather; requires a teamslot; must switch in to activate.
First up, Water-type move boost. The 50% boost is very strong, turing strong Pokemon like Keldeo and Gyrados into wrecking balls, and offensively mediocre Pokemon like Politoed into legitimate threats, as well as making the useful Scald the same effective strength as a Hydro Pump is under clear skies. The 50% decrease to Fire-type moves is extremly beneficial to many defensive Pokemon. Steel types in general appriciate effectively losing one of their few weaknesses, with such beneficiaries as Jirachi and Ferrothorn, which are already great defensive Pokemon. The Fire-type move nerf is also useful against Dragon-types, which often run Fire-type coverage. The boost to Thunder is destructive, allowing many Electric Types to replace Thunderbolt with a 35 BP stronger move and triple the paralysis chance, and the boost to Hurricane gives select Pokemon a 120 BP move with great neutral coverage (among Pokemon ranked OU, better even then Dragon), a 30% chance of confusion, and no drawbacks. The activation of Dry Skin benefits mainly Toxicroak, who can use Black Sludge, Bulk Up, and Drain Punch to become nearly indestructible, or gain 2% hp per turn with Life Orb. Rain Dish is known for being used by Tentacruel, a Pokemon with good defensive typing and stats. Rain Dish gives Tentacruel a method of reliable recovery, making it one of the best, if not the best, Rapid Spinners in OU. Hydration is seen less in OU. The main abuser is Vaporeon, who is very hard to take down between its bulk and one turn Rest (Manaphy also used the ability to net multiple Calm Minds or Tail Glows, but it was sent to Ubers). There is also the ability Swift Swim, which was banned in conjuction with Drizzle for being too powerful). Drizzle also requires little effort to setup and maintain. Activating it requires only that Politoed be sent in, and it will last the entire match unless the opponent switches a weather inducer of thier own in or uses a weather move (a subpar option). And Politoed is not deadweight once rain is set up; someone posted calcs earlier showing that Specs Hydro Pump from Politoed is about as strong as Specs Draco Meteor from Latios.
Drought? Boosts Fire-type moves 50%; Reduces Water-type moves 50%; activates Chlorophyll; makes Growth twice as effective; lasts entire battle; cannot be removed except with weather; requires a teamslot; must switch in to activate.
First up, 50% boost to Fire-type moves. This is very destructive. Fire-type moves hit quite a few defensive Pokemon for supereffective damage already (most Steel-Types, for example), and the boost just makes them hit harder. There are also some real powerhouses among the Fire-type, like Victini, Volcorona, Darmanitan, and Chandelure; the boost just makes them hit with nuclear force (fun fact: 252 Atk Choice Band Victini (+Atk) V-create vs 4 HP/0 Def Kingdra: 53.77% - 63.36% 2 hits to KO). The Water-type move nerf is less useful, as few defensive Pokemon are weak to Water, but it does help Fire-types. The activation of Chlorophyll is one of the biggest boosts of sun, turning formerly slow Pokemon into speed demons, outspeeding even many Scarfers. Growth is another of sun's main attractions, giving the user (often a Chlorophyll user) a Nasty Plot boost and a Swords Dance boost, letting Pokemon become fantastic mixed sweepers. Drought also has a similarly low cost to Drizzle, requiring only a switch to activate, and once again being permanent unless countered with opposing weather. The teamslot used for Ninetails is much less useful than that used by a rain team's Politoed, as Ninetails is almost useless outside of Drought (it can...use Will-o-Wisp, and... that's about it).
Sandstream? Deals 6.25% damage per turn to all Pokemon that are not Rock, Ground, or Steel type. Boosts SpDef of Rock types 50%; Activates the Abilities Sand Rush and Sand Force (also Sand Veil); lasts entire battle; cannot be removed except with weather; requires a teamslot; must switch in to activate.
The passive damage is one of the main features of Sandstream, negating Leftovers for many Pokemon and chipping away at others. The SpDef boost is one of the other selling points, as it makes certain Pokemon (mainly Tyranitar and Terrakion) much harder to KO. Sand Rush, which doubles Speed in sandstorm (and it also negates the passive damage), is the last main selling point, letting Stoutland function as a great revenge killer and late-game sweeper, and Sandslash as a Rapid Spinner/sweeper. Sand Force, which provides a 30% boost to Rock, Ground, and Steel type moves, is seen mainly on physical Landorus-I, which can smash through teams with the boost. Sandstream also has perhaps the lowest cost of all the weathers because while it still requires a teamslot, it can be used by both Hippowdon and Tyraniter, already good Pokemon to begin with. Sandstream also has the low turn cost of switching in, and permantently takes effect unless the opponent counters with another weather.
Snow Warning? Deals 6.25% damage each turn to all Pokemon that are not Ice type; Fixes Blizzards accuracy; Activates the Ice Body ability; lasts entire battle; cannot be removed except with weather; requires a teamslot; must switch in to activate.
The residual damage to Pokemon that are not Ice type is the main feature of hail, negating Leftovers for or chipping away at almost all Pokemon. Blizzard becoming perfectly accurate gives Pokemon that previously used Ice Beam an effective increase of 35 BP, while still retaining the chance to freeze. Activation of Ice Body is the final effect of hail, giving Pokemon with the ability free Leftovers recovery. The only Pokemon seen using this ability are Walrein (using the infamous "Stallrien" set with Substitute and Protect to stall for 32 turns) and Glaceon (which usually runs an more offensive set with Substitute). Hail is the least seen weather for multiple reasons. The first is that few benefits are gained by using hail, compared to other weathers. The second is the difficulty of fitting Abomasnow into a team, as it brings seven weakness to the team, while not contributing much. Abomasnow's main selling points are the ability to beat or greatly damage the other weather inducers one-on-one, and STAB Ice Shard to check Dragons. Indeed, hail is more often used to deny the opponent their own weather than for its own merits. But hail shares the low turn cost of other weathers, requiring only that Abomasnow be switched in, while lasting until replaced with another weather.
Note that for Drizzle, Drought, Sandstream, and Snow Warning I only listed effects you are likely to see in OU.
The various kinds of weather (mainly Drought and Drizzle) stand head and shoulders above all other forms of team support. Weather (once again, mainly Drizzle and Drought) provide much more powerful effects than other forms of team support. They also have a low cost attached to their use, and are difficult to remove.
So why is this a such a bad thing? Let's imagine something for a moment. Let's say that we tiered team support , just like we tier Pokemon. Drought and Drizzle would be clear Ubers, because of how powerful they are in comparison to other forms of team support. The current metagame revolves around weather, in the same way the metagame would revolve around a Uber Pokemon like Ho-Oh if it was made legal in OU. If Ho-Oh came to OU, the metagame would focus on abusing Ho-oh, and countering Ho-Oh
There is a definite correlation here, in the effects weather has on the metagame and the effects an Uber would have on the metagame. Let me be the first to say, however, that correlation does not imply causation. It is perfectly possible that my analogy is simply invalid. I do believe, however, that it is correct, and that weather is simply bad for the metagame.
TL;DR Weather cause the metagame to centralize in the same way that an Uber like Ho-Oh would if allowed in OU.
EDIT: Sorry kd24. I meant to flesh it out before posting, but I was called away unexpectedly. I'm putting the rest of it in quote tags. It may take some time though.
EDIT2: Quote tags with explanations and conclusion are up.