How do people make videos and their own special mods with video games such as oblivion

People can make mods for games such as Oblivion or Half Life 2 by downloading the games SDK "Software Development Kit"
Which usually contains a Level editor, plugins, sourcecode, ect

A 3d art package such as Maya, 3ds Max, XSI, ect is used for making the 3d models and animations.