Favorite Fallout DLCs in order of Most Favorite (1) to Least Favorite (7)
(1) The Pitt, come on it had that unique Atmosphere no other DLC has created, you felt helpless, and overwhelmed, and wayyy out of your comfort zone, and the Steel yard just mega creeped me out. A Very well done DLC, with a classic Spartacus-esque storyline, I really really enjoyed all the concepts introduced with The Pitt, and the Ammo press was godlike for it's time, my Top-reigning pick thus far...
(2) Honest Hearts, It's got Joshua Graham... and he's like Darkman with a Bulletproof Vest! And a blast from the Past with all the Tribals, brings me back to the Fallout2 days and the starting village, I forget it's name, Arefu maybe? Very Beautiful, and exciting DLC
(3) Dead Money, This one was tough, Mothership Zeta definitely isn't far behind here, but Dead Money was by far the most unique and strayed the furthest from the typical gameplay, and you just had to love all the colorful companions, especially DogGod. loved my time with the Siera Madre
(4) Mothership Zeta, ok Beth read my mind when I found the alien encounter in Fallout3 and totally expanded upon it, Aliens, anol Probes, Spaceships, and Ray Guns! What more could you want?! Oh yeah how about a Cowboy, Samurai, an Astronaut, and some other Unique people. What Mothership Zeta lacked in Story it made up for with all the new visuals, great weapons, and smart/annoying enemies, and all the sweet alien items, like the crystals and the epoxy.
(5) Point Lookout, Huge area to explore and it's pretty well fleshed out, it's about 1/6 the size of the Capital Wasteland, and it is litered with ruins, and abandoned buildings, boardwalks, military depots, Redneck Mutants, and a Dangerous Cult that has a mysterious Brainy Mastermind behind it. Oh and don't forget the Cool Ghoul in the Calvert Mansion. That guy was the man! I really enjoyed my time in Point Lookout, the Surgery Scene was very trippy, and an unforgettable fallout moment for me

(Kinda like when I unleashed the Troggs on Ashur's goons.)
(6) Broken Steel, I went into Broken Steel with high hopes and I ended up enjoying it far less than most of the other Fallout DLCs although the Hellfire Armor was def awesome, and the Ending was Simply Epic! Complete with a potential very evil ending and a shiny new Magnum. Poor Liberty Prime :/
(7) Operation Anchorage, Beths first foray into the Fallout DLC and it wasn't a bad DLC it's just not as good as anything else that's been churned out. The story was some what bland and kinda bounced around allover. The combat was kinda odd at some points, with the squad ai and the enemy ai. Overall tho I enjoyed it and the cool little touches like the Snowmen. The last simulator battle had the potential to be epic, and it seemed like it was going to be when you and your squad charged across the open tundra guns blazing, but once inside it kinda turned into some weird matrix-esque showdown.
I can't wait for Old World Blues and Lonesome Road, and then I'll have the complete Fallout DLC collection to mess around with and run my character through with a Reqiuem for the Capital Wasteland *Hugs Himself and Rolls Around the Bed*