It adjusts air/fuel ratio signals and timing to net a small bump in power. Also it offers different maps which adjust the throttle response.
http://burgertuning.com/BMS_Power_Box.html
^^^ Good breakdown of the functions of each map and the Powerbox itself.
As for whether this is a good mod, I haven't heard of any people regretting it.