it’s difficult to see how a naturally aspirated engine will show huge gains just from remapping.
Because manufacturers detune versions to meet things like company car tax brackets, low road tax and insurance etc.
As mentioned the early-2000s NA 1.6 Mini One and Cooper were mechanically identical but the One was 90hp, the Cooper was 115. Just software.
The 60hp VW Up/Polo (and loads of derivatives) is mechanically the same engine as the 75hp version, just a different ECU.
Both can be loaded with the map of the higher output version giving big gains. Having said that, often the gain is marginal for normal driving as the extra power is at the top end of the rev range and torque increases are not as high. The Up for example has matching power/torque curves until about 5-6000 rpm so no noticeable change unless you rag it.
However, the gains on the already higher tuned NA models are much, much smaller for the reasons you highlight.