Value, I understand that.
Cost per HP, yep I get that too.
Potential warranty loss, check.
All that being said, if the person modifying their car goes into it with their eyes open while fully understanding these issues (or potential issues), then I go right back to my initial point. Why all the fuss by people who don't want to modify their cars?
I haven't seen anybody making a lot of fuss. What I see is people who have "been there, done that" sharing their wisdom and friendly advice. Not becoming upset or telling them they can't go down that path.
A bike example, I bought a brand new KTM990Adventure in '12 with 1 mile on the clock (I almost never buy new bikes). At 500 miles, I dropped the oil/filter performed a valve clearance adjustment and then modded the hell out of that bike (intake/exhaust/ecu tuning, suspension, lighting, seating, controls, you name it). Did any of that void my warranty, nope(yeah, surprised me too). Could it have, yep. I just didn't care, I wanted the full 105Hp, I wanted LED lighting, blah blah blah.
Nothing wrong with that if that's what you want. I have two identical 2002 Ducati ST4s's (with the 996cc 90 degree V's). Well they were identical until I replaced the ECU on one of them with a Ducati Performance ECU, replaced the pipes with carbon fiber, replaced the OEM air filter with a pleated oiled cotton gauze filter, installed lighter forged wheels, titanium axle, carbon fiber fenders front and rear, replaced the OEM single headlight with a double projector unit that is wired directly to the battery through two dedicated relays, added heated grips and a 12V outlet for heated jacket, sculpted a new seat with better foam, rewired the headlight so it would not illuminate when the starter was cranking, added a special circuit so the engine could be started while the bike was resting on the sidestand with the clutch out (but only if the bike was in neutral), installed adjustable brake and clutch levers, bent the fairing mounts so I could adjust the steering stop to get a tighter turning radius for slow speed maneuvers, installed a hard-anodized clutch basket with tighter clearances to the tangs on the friction plates which required custom filing of the tangs to fit (this provides more longevity and better clutch feel) and a bunch of other stuff I can't remember. I also finely tuned the desmodromic valve clearances for longer valve service intervals and smoother running.
Now some of these mods/procedures I've done to both bikes but one bike has no mods that increased HP or sound levels. It's civilized and quiet at idle and when riding normally in traffic but makes beautiful noises when opened up all the way to just above 10,000 rpm. The other one has an exhaust note that is loud, deep and throaty, even while idling, when opened up it sounds like nothing else. I call it my wildebeest:
Here's the thing - the stock bike makes 121 HP and the opened up bike makes about 5 more HP, just enough to feel with my butt dyno (or is it an illusion caused by the loud, badass roar of the open airbox and pipes)? Both bikes are deadly fast by automotive standards, neither are fast compared to fast but porky and ill handling bikes like a Hayabusa. At least not in a drag race (but either Ducati would leave the Hayabusa in the dust if there were enough curves to be worth the ride). And I actually prefer the quieter bike, even for sporty riding. Of course the loud bike make one feel like a hooligan which is occasionally a good thing. On a track the loud bike would have marginally faster lap times but it's not a big enough of a difference to add or subtract significantly from the sport of it all. It's still about rider skill, not a small gain in HP. Oh, and the first time I serviced the loud bike after returning from a 5,000 mile ride of a mostly twisty, sporting nature, the "clean" side of the airbox was full of road grit, fine, gritty sand that felt like what might be affixed to 280 grit sandpaper. Now I smear a thin film of dielectric grease on the clean side of the airbox to check for filtering problems. I put the paper filter back in. No loss of power and no sand in my airbox. Thinking I didn't have a good seal with the filter, I greased up the seal of the cotton gauze filter, oiled the gauze up real good and took a 4,500 mile sporting ride. On my return, my airbox was full of grit again. You see, the engine is moving a lot of air to make all that HP at full honk and the dirt gets sucked right through the oiled cotton gauze. Needless to say, I've given up on the gauze filters. Plenty of my riding buddies have confirmed the same thing - they just don't filter well enough to be practical and I've seen dyno results from one of the more experienced (and objective) bike dyno operators in the world that confirmed there is no power gained on a Ducati 996 engine by switching to a gauze filter (even though he used an exhaust gas analyzer to insure the FI was at the sweet spot for each setup). Of course that doesn't stop advertisers from claiming it does add significant power. I know I can switch back and forth and not feel a thing.
Personally, I think vehicle modification is about passion! Not warranties and resale values. (nana)
My point about the warranty was simply, if someone can't afford a more powerful engine off the lot, it doesn't make much sense to try to build a less powerful one into that engine. It's gonna cost you one way or the other. And there is no practical way to get much extra out of a CX-5 engine to begin with. How much passion should one have about spending a bunch of money to get little or nothing back?