I have an '04 3.0 6MT with the Dinan CAI, free-flow exhaust and upgraded engine s/w. It adds approx 13 hp and 11ft/lbs, crisps-up the throttle response, add a couple hundred rpm to the redline. The exhaust has a nice thraty burble around town, but is quite transparent at hiway speeds (no drone or booming). Interestingly, my mpg went up 1-2 mpg in 'normal' driving (it do get thirsty if you're on it a lot). Thirteen hp isn't a reall big kick in a 4000# vehicle (especially at 7000' in Santa Fe), but it is a noticeable improvement. I don't know that Dinan is still offering teh CAI, I had a couple of 'lean burn' faults (SES light came on) when I first had everything installed, but the dealer worked with Dinan and it's been fine for the last 2+ years.
All in all, I'm happy with the upgrades. HTH.