Thought i'd share a sample of gameplay/content related mods for users to see what the modding community can do.

Keep in mind these mods are pre-CK. This means that creation of mods at this point is very hard and there are a lot of restrictions to what someone can add/change.
After the CK is released and the couple of years after that, expect myriads of mods changing the game in every way you want or adding tons of professional level new content.
I also made this thread to help some people choose between the console/PC version of the game and give them a taste of the PC version mods benefit.

Check the links below the mods for details and changelogs.


PISE - "improved skyrim experience"
Makes everything more random, widens the scaling of the enemies and the loot while making rare loot more rare but obtainable at lower levels to add interest and more surprises in the game. It also does a lot more.
http://www.skyrimnexus.com/downloads/file.php?id=1269

Tytanis ultimate mod
Adds a hell lot of stuff, many dozens of new craftable items and many other features. Plans to add more perks, skills, mounts etc. Has a few other content adding mods integrated in it.
http://www.skyrimnexus.com/downloads/file.php?id=1601

Midas magic pre-release
Worked on Oblivion too. Plans to add spells in a balanced way or available through challenges and quests.
This many spells before the CK. Can't wait to see what will happen after the CK.
http://www.skyrimnexus.com/downloads/file.php?id=3413