I've finished the main quest, IMO the end is a bit underwhelming.
It will be interesting to see if the choice you make at the very end will have material effects on the Mojave, like Broken Steel did to the vanilla Fallout 3 ending.
The new weapons are a bit hit and miss. The new rocket launcher is pretty much a no-go for hardcore mode because the ammos are so heavy. The new unarmed weapon is pretty good though.
On the whole I would rate this DLC maybe the worst of the bunch, on par with Honest Hearts in terms of disappointing narratives. Just as they failed to flesh out the Burned Man, Ulysses here is just boring. It is solid without being memorable.