as the poisons but in spell form. scaled to level, alteration school. sorry but the last place I want my mage is in melee, and melee is the only way to not have to take the time to change out hands to be able to cast spells.

Alteration School, paralyze. You don't need anything else, it pretty much wins the game against nearly anything.

meant weakness to fire, frost, etc.

This needs to be part of a much larger mod. All the spells that are only available for alchemists and enchanters need to get back to the magic schools, such as shock shield, weakness to magic, cure disease, fortify skill, etc.

I think this is by design, not because of a mod.

Alchemy in this game has a much greater effect than it did in oblivion. With the removal of cure poison/cure disease spells you are forced to either find, buy or make potions, making alchemy more viable. Fortify skill is out for the same reason, making alchemy actually worth something, since you can use the restoration tree to pretty much restore stamina and hp VERY quickly, and magicka regeneration is boosted. Weakness to magic is i think needless, unless you're playing something higher than adept at least. My battlemage has 100 in destruction, and he can pretty much stand and take the brunt force of a dragon's Thu'um and just spark it up with his lightning storm. The weaker dragons i kill before landing (they need to be stronger >>, dragons in general).

Pretty much, the magic in Skyrim works the way it's intended to, to get more things, you need to either be an alchemist (which is not hard, you don't even need perks to be semi-decent), or buy potions. I do agree that poisons that make targets weaker to magicka is a bit lame if you're playing a full mage, but that's just a trade-off you have to live with.

Adding a mod like this will again, make alchemy worthless. In oblivion it was utterly pointless, unless you were raising your intelligence. Here at least it makes more sense to use it.

No, not at all. Alchemy has its own inherent advantages. You can use potions mid-combat without having to change your hand-layout, and you can create effects from all magic schools combined with just one skill. To get the same effects without alchemy, you'd have to invest much more perks in other skills.