I don't think the scope figures out exactly what probe model is connected; the manual says you have to dial it in. That would be some major reverse engineering of Tek's I2C interface if it did.
The Tek power supply (1103) gives you two seats, the adapter is one for about the same price.
I have the Agilent equivalent of the Rigol adapter, and I must say it's extremely convenient not to deal with the coax and external power supply to do a quick measurement with a Tek probe. I don't regret buying a pair of them. (And you have to tell the Agilent which probe is connected too.)
The only thing I don't like is the major lever these adapters create with some of the bigger Tek compensation boxes. I haven't snapped anything off yet...