Couldn't have said it better!Yeah I'd avoid AFM but it is possible to disable / remove. [I wonder if you could get a deal on a vehicle with bad AFM? then slide in a better cam. More work I know, but maybe you can get a good deal going this path.]
I think, and going off memory, when the 6AT came out, it became harder to get "good" rear gearing. Thing is, it became less important. The 4L60 and related had a 3.06:1 first gear. The 6AT's were like 4:1. That deeper first gear ratio "makes up" for the rear end being a bit taller. That said, I always thought 3.42 was a bit too tall, and 3.73 was better. I'm just not sure if you could get 3.73's.
Casual looking and I almost never see the build sheet / RPO codes given. A few sites will state what the rear gears are. If you can get the VIN though, there is a VIN lookup site that will tell what that truck got for rear gears. I think I usually find it under "GM VIN decoder". That's for if you are doing online shopping--if you are going in person, jot down the RPO codes for the rear gears and have that handy, and find the RPO sheet (is it still in the glovebox?).
In SUV form 2000-2006 would be Generation III LS-based which is a 24x crank and 1x cam gear. No AFM in these engines. 2007-2014 would be Generation IV LS-based which is 58x crank and 4x cam gear. Some of these have AFM.
Don't forget you have the Cadillac Escalade ESV as your Caddy Suburban variant.
In 2001-2006 Yukon XL Denali's came with the LQ4 6.0. They do have an AWD transfer case. Additionally, similarly, yet different 2003-2006 Escalade ESV's came with the LQ9 6.0. Same thing, AWD transfer case.
Also, the 2006 Suburban LTZ (kinda a unique model/trim/config for the year), has a LQ4 6.0, AWD transfer case, special interior and other body items. Think of it as a close cousin to the Yukon XL Denali.
In all 2000-2006 1/2-ton GM SUVs, you'll have a 4L60e, 4L65e in the Caddilac and Denalis.
2007-14 trucks -- 2007 and 2008 you will again have a 4L60e, 2009 and up will have a 6L80e. 2009 and up you also have a potential for a 6.2 V8. All Escalades from 07-14 are 6.2 with a 6L80e. I don't know for sure but think the 6.2s in the Escalades were without AFM.