The Elder Scrolls IV: Oblivion Construction Set is designed for the player to edit and create new content in The Elder Scrolls IV: Oblivion. The CS (Construction Set) can both be a basic and advanced tool, depending on what one plans to accomplish. With it, you can do anything, from creating one's own dimension, dungeon, or even city to adding a new NPC or house. It is possible to revamp the game, with or without help. If one has the computer editing know-how, then they can feel free to create a new race, new bodies (such as body adjusters for fitness, bust, legs, height etc.), classes and Birthsigns. One can make the Imperial City look more modern, remove a city, recreate Morrowind - one could even change the Main Quest, such as it suits them.
One thing one must be very careful about is the use of a "dirty" mod. This is a mod which conflicts with another mod. (Obviously, if one does not plan on downloading other mods, or uploading their own, this shouldn't be a problem). For example, if a mod has nudged a rock or torch accidentally, or even on purpose, and a second mod has moved the rock or torch in a different way, these mods will conflict, and the modded game will register an error and crash. This is also very important to remember when making and uploading mods for others to use.
One good example of the powers of the construction set is the mod, called Nehrim - at Fate's Edge. This particular mod has been in development for four years and completely revamps the game. This is a fan-developed game with the aspiration to be able to compete with full-grown commercial RPGs. With an estimated playing time of 50 hours, over 60 Quests and thoroughly synchronized dialogues by professional voice actors, new weapons, armor, spells, races, models, video-sequences, specially composed new music and much more, this does not seem that far-fetched.
The CS has its own wiki, in which their many tutorials can tell one everything they need to know.