The most important one is probably Broken Steel, which lets you continue after the Main Game ends, and raises your level cap to 30.
But yeah, the DLCs are pretty much extra stages that take place in different enviroments. The Pitt, for example, takes place in Pittsburgh. You can get new skills, weapons, quests and armor.
Hope that helps.