I thought that The Ballad Of Gay Tony was great.
Far better than the Vanilla.
Anyway, no Fallout does not always have the good DLC.
MA and Broken Steel for example.
MZ had it's interesting parts and a great concept but it was a linear run and gun corridor shooter with meatshield aliens.
And Broken Steel broke the game and made the already bad ending worse.
There have been other DLC's which are good.
Undead Nightmare for RDR was ten times better than the vanilla.
Left 4 Dead's DLC's are all great as well. Even Crash Course.
Borderlands DLC's were also very fun and added new interesting things to the game. (Haven't played Claptraps(This is a word?) Revolution though.)
Shivering Isles was also very good.
Other than that I have not bought any DLC's so I couldn't comment but I wouldn't say Fallout = good DLC's.