CAI's won't add much power on their own, but used in conjunction with other intake/expulsion mods (a larger MAF, throttle body, plenum (70mm/75mm), headers and straight thru aftermarket mid-pipes/mufflers/catback) will yield nice results overall and sound truly like a race car.
There are a lot of restrictions in the stock air flow systems (air box, TB, plenum, exhaust manifold, mid-pipes, stock mufflers, etc.) so just putting on a CAI has little positive effect on its own. You have to address all the restrictive areas with larger components and then, working in concert with each other, the larger components mentioned above all jointly yield more power. If you are looking for power gains it makes no sense to have a CAI if keeping the stock exhaust manifold/mid-pipes/mufflers/tail pipes, still restricts flow. But open it all up at the same time and that's when you will see gains. Make sense?