I’m in Chevy sales so, FWIW, although I haven’t owned them myself long-term, I’ve had more than a test drive behind the wheel of the new Tahoes and Suburbans.
The 10-speed is the transmission you want. If you’re looking at a slightly older Tahoe, avoid the 8-speeds. Heard nothing but issues...