All the DLCs are pretty bad. I would love to trade the other three for an enhanced Honest Hearts though. A bigger world, an actually compelling story, a glimpse into world of Fallout outside of the most civilized areas. "The plague of tribal identities" straight out of Van Buren, interactions with the tribes and their goals and power struggles, abandoned ruins picked over by ignorant savages, a little outpost of civilization, perhaps in the form of New Canaanites, where the religious/moral conflict could be expanded upon, survival mechanics necessitated by a need to survive the tribal way deep in the wild, far from luxuries of Vegas or NCR. It would be an interesting expansion to the setting, one that could avoid the sin of the actual DLCs - they had nothing to do with the main story of the game, didn't expand upon it in any way, instead presenting boring side characters I couldn't give to shits about.
More specific criticisms:
Dead Money - frustratingly slow, put its money on horror style survival by depriving you of your stuff and then, five minutes in, just gave you all you need to fight head on, just worse than what you already had. Elijah's motivations make no fucking sense what-so-ever, like the writers couldn't decide if he is the BoS Elder and Veronica's mentor from the base game or a wannabe Presper.
Honest Hearts - seriously... The main story is just three super-generic, easy and quick fetch quests followed by a final assault (because who chooses Daniel) which didn't require those items anyway. Absolute zero of exploration of tribal culture, way of life, warfare or politics made for an extremely bland and disappointing experience - do compare with Van Buren design documents about tribes.
Old World Blues - a joke that wears out its welcome long before the initial conversation is over and from then its only more tedium. Repeating missions through the same corridors over and over, fighting HP-bloated enemies, reading uninteresting log entries. If it wasn't for the perks you get out of it, I wouldn't replay it at all. It's the DLC that I find the most tiresome and reluctant to play through.
Lonesome Road - bearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbullbearbull JESUS CHRIST SHUT THE FUCK UP YOU FUCKING RETARD. We don't know who Ulysses is, only that he holds some grudge against the Courier and won't stop whining about it in the most unintelligible manner - the first time I played I started to brute force click through his dialogue about half way through the DLC and haven't went back since. The vertical exploration of a world in all shades of grey also doesn't work, I couldn't see enemies or paths through the rubble for jack shit.