well with n/a piston engines, running a larger intake pipe, larger exhaust pipe and porting the cylinder head will shift the power band from stock.
stock is typically designed to provide the flatest torque curve possible over the usuable rpm range for easy daily driving. If slapping a big intake or exhaust pipe on a car was really that good of an idea for the everyday end user Mazda would have done it themselves.
modifying the diameters of the pipes and ports significantly effect powerband. IE with larger everything you typically lose low end power and gain top end power.
The length of the intake pipe also plays a key factor in tuning (converting from a short intake to a long intake makes a difference in resonation characteristics).
Usually people look into this stuff and run some simple calculations to find the right combination by factoring in some basic variables (desired peak HP RPM, intake pipe diameter and length, exhaust pipe diameter, port sizes/shapes, exhaust pressure etc) to make max power at desired RPM before they start buying parts.
In performance applications you typically sacrifice power and response "under the curve" IE 1000-3500RPM to gain power in the top end as this is where you spend all your time when you are racing.
In non performance driving (IE not redlining your car every gear) the stock setup may actually make more power @ X rpm then a modded setup, especially when dealing with modified ports, manifolds, camshafts and anything else that drastically alters the engines volumetric efficiency (VE).
so while that lotus in the show (I watched that too btw) gained some peak HP, you can bet it would be down on power in the low end. not to mention it would have poor low rpm and cold start emissions (larger ports = poor airflow at low rpm = poor fuel atomization and fuel scavenging).
It is always important to size your mods to the actual CFM that will flow through the motor. IE: No sense in having a intake/exhaust/cam that can support 400 CFM @ 7000RPM when your motor flows 150CFM @ 7000RPM etc.
Its all about matching things correctly to get the best gains.
There are tons of books and online info regarding tuning n/a engines if you guys are interested google has everything you would ever need to know.