I agree its really hit or miss, but both by maintenance and also how hard you are on them.
My PPV was North Carolina State Highway Patrol vehicle. When I purchased it, it came from auction freshly stripped of all equipment and vinyl, with 179k miles. It came with a complete service history from the day NCSHP purchased it, down to line items for outfitting radio/sirens, to every light bulb and oil change, even every tire replacement and the last item being the decommissioning. Original 5.3, original 6L80. Beyond subject to infinite WOT runs, I think most are more concerned with engine idle hours, as these trucks can sit at large events for hours just idling.
With that said, I had the DoD deleted in the ECM but still have the original hardware inside the engine. The engine tune was only slightly modified, and the transmission was tuned as well (removing converter lockup at low speeds was the biggest, although some pressures were slightly increased). I've got over 278k miles on my Tahoe now. I've done a water pump and a TPS sensor, thats really about it as far as "repairs". Certainly I've changed out a lot more parts, but voluntary (stereo, wheels/tires, suspension, etc). The only thing I've got on my plate to fix today is the notorious fuel-filling issue, where at most pumps I can't set it to fill and forget it. Just a matter of checking out the venting system for the fuel filler neck, which has actually been an issue for this Tahoe since I got it (very common).
So yeah, its definitely hit or miss. I have zero regrets, and if I was in the same spot the day I bought my Tahoe, I absolutely would do it again and buy the exact same truck.