Point Lookout was pretty tedious if you ask me. There were a few cool moments, but other than that it was pretty boring.
I found the storyline to be very underwhelming, two petty sociopaths bickering over some old feud. It was probably the second best of Fallout 3's DLC after the Pitt, but that's not saying much.