A400 is the last aircraft I'd use for delivering SF. It's tactical in that you can land it on unprepared strips, but its rather big, even for a platoon. It's more a pantechnicon for company sized stuff.The NH90 has had many issues, not surprisingly a few users have chosen to bin them and Go with the MH60s, the A400 works for us, due to experienced ground crew, aircrew. It’s still not fit for purpose for delivering SF, hence why the RAF will be getting MC130J for that purpose, along with MH47G.
If Tigre was so good, why is the Apache out selling it?
France needs new MPA, Heavy SH, a replacement for the medium transports that @fantassin has alluded too, however I don’t see Airbus as the answer To any of those requirements.
SF Chinooks would probably be a better bet in most cases as you can put then down on a tennis court, not summat you can do with a C130. That said, if you want an LRDG type sweep with landys and jackals , C130/C27 would be good to haul the bulk with.
The Tigre won't outsell the Apache because the US army requirement is probably bigger than the rest of NATO combined. The targeting systems on it are very good according to the Ozzie's. Unfortunately you won't get the Apaches Longbow radar on Tigre which is a pity as it's a cracking bit of kit.
Performance ? Here again the French seem to have got results. There were issues with the engines in Oz, but none with the French or Spanish ( and it's the same ones we use in Merlin ). Is it possibly a batch issue? Dunno.