From my experiences and observations, usually the transmission will crap out way before the motor does. Maintenance is the key...regular frequent oil changes and no beatings on a cold motor.
The stock Camry motor is very durable... like most Toyotas, they come with pretty beefy parts and were "built for more power" originally, mainly because we have motors that should make more power, but it was detuned and tuned conservatively.
My Camry has 175000 kms now, and I turbocharged it about 8000 kms ago...haha And I can't believe it hasn't burned a drop of oil yet at 16 lbs... amazing. Well, except for the fact that the pistons were chunking off

But that was tuner's error mostly. It's not going to last forever, but if you boosted a stock honda motor with that mileage, it will go to heaven the first day you rev it