I have the DTH single and I like it a lot. It's pretty easy install, even for a guy who hasn't been wrenching cars for the last 2 decades - took me about an hour.
I don't know if performance really is enhanced or it just gives that perception. I challenged my buddy in his DB-9 but he was too busy laughing to find the gas so I guess we'll never know if we would have had proof...
Needless to say, it's fun, it gives an attitude uplift and, for that alone, is well worth it.
The only "con" is that is does interfere a bit with listening to music on your "premium" sound system. I've only had mine on for about 8-900 miles and some on the forum have said that it mellows out a bit as it gets broken in. If that's true then that only "con" will drop in significance.