Tahoes seem to be fairly bulletproof and simple/cheap to fix. I wouldn’t be scared of one used.
But yeah, the residuals on these are absolutely terrible. This is typical of the top trim of any vehicle, it doesn’t really make any sense to lease unless it’s a unicorn deal. If you are set on leasing a full size SUV, stick to relatively basic models. Real life residuals on these things are even worse so do not finance a new one. Here’s a Pemier at ~55% of its MSRP after 1 year and 37k miles. Yikes. These things drop like a rock the first couple years.