The ability to farm the treasure room is worth the price of the dlc by itself. You can not only snag legendaries in there, but it also seems to be a damn good place to farm E-Tech weapons.
Isn't Pete in that dlc? If so, he's worth the 800msp by himself. He has dropped so many legendaries for me so far.