Agreeing with Spazdog above, I think it's relative to the design. In a perfect world, every automatic transmission out there would last forever. But, we have imperfect designs (we are all human), and all of them don't.
I had an '84 Cutlass with a RWD TH-200-C that was notoriously weak. Mine quit at less than 100k miles, with the common breakage: no reverse gear. I elected to have it re-built, and it was fine until I sold the car with 135k miles on it.
Chrysler's earlier A604/41TE transmissions aren't known for their longevity. After around 2000 or so, they seem to have gotten most of the bugs worked out, and most last well into the first 100k miles. Even Chrysler's RWD transmissions have had poor histories, though their modern units are very nice. The early Grand Cherokees and Dakotas and other 42LE/44LE applications were noted to have average or below average transmission life.
Honda's earlier V-6 transmissions aren't known for stellar life either. Most of their 4-cylinder units, and their later V-6 units, seem to fare better.
The common theme here is FWD transmissions, due to any number of things, don't typically last as long as RWD designs. There are some FWD designs that last longer than others, but on average, I would say that many FWD units are near the end of their life span by 150k miles. This number is probably growing as transmissions in general continue to improve. RWD transmissions, in general, seem to last longer.