Some mods will require other mods to work, some mods might conflict with each other, some might not work at all, and some, inevitably, will slip some of that nudity and copyrighted material in there anyway. That means it will definitely be possible to totally mess up your game, something that console players are not quite used to yet. After that, the most important advice is to be careful: Bethesda has said that it's going to be cracking down on nudity and copyrighted content for console mods, but it's also trying to get out of the way as much as possible.
