In my opinion the DLCs are DM > LR/OWB > HH. I wasn't too big on Honest Hearts.
Pretty much also my own opinion. I understand what Sawyer was going for with Honest Hearts and I would not have minded such a DLC, an expansion with more contemporary elements compared to the other three which draw much more heavily from the past (Pre War world).
But I found the campaign just very underwhelming, the quests had some of the same issues as OWB would have; a lot of fetch quests at the beginning.
Eventually you get to do more actions against the White Legs and there is some side material that has nothing to do with the situation involving the Dead Horses/Sorrows vs the White Leg, but outside them and tracking down the traces of the Survivalist Zion feels very empty, especially once all the quests are done.
I think designers should have considered adding some non tribals to the region such as prospectors, traders, hunters, (slavers?), perhaps keeping the Happy Trails caravan alive at the beginning and have some more storyline and quests with them as well instead of discarding them.
The problems with OWB are I think is that the opening can be very verbose when you meet the Think Tank. Now I love learning more about the Fallout world and its characters but the conversation with the Think Tank can take a lot of time and if your skills are high enough you also afterwards talk with each of the scientists in order to pass skill tests to earn items or exp before you can finally continue to explore the Big Empty.
The middle of the game is quite devoid of conversation (unless you still need to complete some of the Think Tank's side quests) and I spend most of the time going to the various secondary locations to collect personality chips for the Sink, weapons, and everything else that can be used for crafting or can be recycled, and of course to complete some minor skill checks.
Then the end of the game it becomes very conversation heavy again after you have dealt with the Giant Roboscorpion, first Mobius and your brain, and then the Think Tank again.
What I forgot to mention but what is also important, while some of the humor is perhaps humorous and surprising at the beginning, a couple of the jokes may drag on to long, and when you play the DLC again may outstay their welcome.
The Big MT is quite a big area to explore but other than shooting, collecting, going through old computer records it is indeed quite empty despite all the set pieces (mind you FO3 DLC such as Point Lookout also had somewhat similar issues)
A smaller more straightforward designed DLC might have been better, or more content to the Big MT map other than having to go through some places several times to collect everything.
All four DLC will probably have their supporters and critics and people who feel ambivalent about all or some of the entries, they are definitely not a complete package like New Vegas was.
Still I do feel that quality wise all of them were better than those of FO3 (The Pitt had potential, Point Lookout was both wasteful and an excuse for Lovecraft references) and those of Fallout 4 (Far Harbor was just Point Lookout 2.0, bring back two factions of the main game most gamers don't care for. And I can't even really talk about Nuka World as it sounded so boring to me, the player going around recruiting or destroying raiders, at the end being able to ally or control them and send them into the Commonwealth. The player should have been able to ally with raiders in the base game. There is something with a frozen head I think which is a rip off of Mr House. And the Huboglobists who for reason are at the East Coast and have been made so stupid that they see an old theme park attraction for a real spaceship)