I seem to remember Kev ran an otherwise standard bike with Carbon Cans only and got a 2hp increase in power. Then there's the weight saving, lack of catalysts, the improved aesthetics and the more fruity soundtrack. Looks and sound of course are all personal taste though.
IMHO, I'd say it is worth it, but it isn't a cheapest mod/way to get extra horsepower. Modifying the airbox, filters and fuelling gives you more hp/euro spent.
I found the dyno results for the Carbon Cans only, it was +2.2hp. Read this thread...
http://www.xt660.com/showthread.php?t=4509