if your goals are thoes possible with a supra or 300zx then skip the camry. the BIGGEST difference is that they are rwd which is what ya really want. but other then that, they are purpose built cars and not some econobox ya made "fast". that being said. the two choices which you can find out more about a bit of searching are turboing a 3vzfe/1mz or swapping a 3s(5s)gte. but you will still be looking at a fwd car so your power is limited to traction.
OH and welcome to TN.
OH and welcome to TN.