Most of what folks accomplish with the tuning is removing the "limits" GM provides. Everything is about tradeoffs.
Even decreasing the PE delay will result in less fuel economy and more overall drivetrain wear.
You have to decide if the priority is power or conservatism with the goal of maximum reliability.
Decreasing Power Enrichment delay only results in less fuel economy if the driver 'takes advantage'.
However, the prime purpose of Power Enrichment is cylinder cooling at sustained high loads, not more power -
GM's PE AFR is a bit too rich to make much more power - 'more drivetrain wear' doesn't apply to the engine.
Making the PE AFR slightly less rich than GM OE spec actually improves fuel economy while making more power, when the driver so chooses.
As for the 4L60E, carefully revised line pressure and shift time adjustments minimize drivetrain wear better than GM OE in certain cases -
especially in the case of the LQ9 (again, unless the driver abuses it).
You decide if the priority is power or conservatism with your foot, and by talking to your tuner about what you want out of the tune.
Although I'd avoid it, there's such things as hypermiler tunes, for example. Do your due diligence and find a tuner who will listen to what you want out of it.
If you settle for a canned tune, yea, tradeoffs, because those don't bother with anything that isn't instantly obvious all the time and cater to stereotypes.
Hey, if you want the LQ9 to last a bit longer, feel free to ask the tuner for WOT upshifts 100-250RpM SOONER than GM OE.
Let's say you always tow / haul near the spec limit. You can have the Tow / Haul shift table improved.
In my case I had my Normal shift table programmed to slightly discourage me from driving like an @$$ (WOT upshifts happen 250RPM under OE spec),
while tuning my Tow / Haul shift table more like a Performance mode, since I'll never tow anything with it - helps when I drive Mom to hospital.
Although it took a bit of doing, I even got my tuner to tune 'Hot Mode' to come on far sooner than GM OE.
When my Tahoe was about to overheat (230F), the engine and transmission started running very differently, keeping a bit cooler (2 electric fans help too),
which gave me another precious minute to avoid making a traffic jam worse before pulling over @ 239F.