Couldn't sleep last night so downloaded the other DLC trailers. Point Lookout is the one that really grabs me; it looks more Resi/Silent Hill-y than the rest of the game, although I've already got Broken Steel I'll be buying GOTY this weekend.
Inevitably though, I suppose the RPG element of the story, the personal story side to it, is diminished with these extensions but the quality looks superb. Could spend 200 hours on the damn thing...