Short answer: no
Long answer: it depends...
To paraphrase my old buddy Carnot: "The output of a combustion engine is only determined by the achieved temperature difference." That leaves two 'knobs' to play with, the intake temperature and the maximum thermal energy released during the work cycle. The former is why turbo/supercharged engines often use an intercooler. The original CAI was also based on this idea, however modern engines typically don't draw air from under the hood anymore (Jeep TJ is one that still does it).
To get more energy out of the work cycle basically requires to get more air/fuel mixture into the cylinder. This is why 'classic' tuning (larger valves, camshafts, free flowing intakes, higher compression ratios etc.) gain significantly more power than just fuzzing around with the air/fuel ratios and ignition timing. Granted modern engines tend to run on the lean side for fuel efficiency so making it richer will gain a little at the expense of MPG.
One of the dirty little secrets of the 'performance' industry is that pretty much all changes are only effective at WOT. In normal operation the engine runs in 'closed loop' to avoid throwing codes.
To sum it up, if the engines runs frequently at WOT and has some modifications that allow for more air to get into the cylinder then a tuner is useful. For a stock engine the benefits are minimal.