Well, this diatribe will likely get me some negative replies. But it is given based on much experience.
My 6.2 2011 Yukon Denali XL was definitely tuned to provide a noticeable difference when fed premium. That being said, I ran regular gas for 195,000 miles. Then feeling rich on a mountainous road trip, I ran a tank of premium. I was startled by the power increase when passing on two lane roads. Don't let anyone tell you that you must run premium. The engine electronically adjusts to the fuel that you use without problems or consequences.
Now for the fun part. I have a 6.2 mystery motor in my 2023 Yukon Denali XL. I have not checked it out yet but the wife (her car) has scheduled an appointment. I still would order a 6.2. Why?
My turbo in my 2011 6.2 never gave me the first inkling of problem. Wait, I did not have a turbo. Turbos are running virtually full time and work ******* an under-powered diesel engine. If you expect to put 75,000 miles on a your new Tahoe then a turbo will likely work out OK. If you expect to put more, I don't understand why an under powered turbo diesel is even part of the discussion.
If your son-in-law thinks you will get more miles out of a diesel, think again. I traded the wife's 2011 6.2 with 203,000 absolutely trouble free miles (except for two broken exhaust manifold bolts, and they cured that problem). It used zero oil between 5,000 mile Amsoil filter changes and 10,000 mile Amsoil Signature 5/30 oil changes. That is precisely why I bought so many of those platforms. I suggest your turbo will not last that long in a 3.0.
Gas is always available at any station I stop. Diesel is not always that available.
My view is colored by my 1984, 1985 (340,000 miles), 1987, and 2001 (340,000 miles) Suburbans. The 2011 6.2 (203,000 miles) was a very welcome addition with a substantial gain in power and luxury. I expect my 2023 6.2 (28,000 miles) to do the same. It may need an engine replacement, but all that means is it will go more miles before I replace it.
I suspect someone's posterior has been blistered for the dumb butt mistake of not inspecting parts they were receiving. Whoever has probably been demoted to a Senior VP position.
Don't let anyone scare you about ordering a 6.2 today.