I didn't enjoy that one as much. There's some terminal lore and some easter eggs, as well as the Talon company armor and the classic outfits (which are admittedly high quality), but aside from that it didn't really bowl me over. I was disappointed that you didn't get much of a story about what has happened in the Capital Wasteland since FO3 even though you are literally traveling there. I know contracts and other issues prevented new voice acting and story, but that made it really seem hollow to me. No Three Dog, no real explanation of where he went other than that he disappeared. I will say, though, there's an opportunity to recruit a buttload of potential settlers though - much like the Gunners vs. Minutemen CC. That can certainly help with SS2!
Since I used to be primarily an xbox player, though, that may be enough in your situation. Seeing as how CC does not count against mod limits you take what extra content you can get. When I switched over to being a PC player though, some of the CC seems even less of a value proposition to me than it did before given the incredible array of big quest mods with full professional voice acting that have been released on PC. Make of that what you will. That 2 GB limit is rough, so it's understandable to look for ways to get around it and the CC sorta is.