If I could find a rust free 99-01 club cab 4x4 with miles like the one you found and a 5.2 I'd be on like Donkey Kong. For the right price I'd pick up the one you're looking at, but I'd probably just go right to the compression test and then probably heads. In mine I tried a set of Reman flow matched injectors first. Didn't hurt anything, but not really needed. Wish somebody would have told me about the heads early on.
As for the transmission, they're not that bad. They're based on the old TF727. Most of the issues stem from the stuff added on in later years like overdrive and electronic controls. The 46RE especially is probably a gold mine for Aamco and some other transmission shops that get one in behaving wonky and sell a rebuild. The governor pressure solenoid is a common problem, replace it with an upgraded type at the first sign of trouble (or when you change fluid), run a big *** add on cooler, synthetic fluid and Lifeguard Silver and you'll get a lot more miles on it.