A camry is dog slow, including the V6s, so if you even have a clue how to drive your car on a track, you should kill it. And a stock 05 RSX-S will run 14.50s stock in capable hands. The Camry? 16.50s with a 4 cylinder, if it's lucky.
Some basic stats about each car:
2005 RSX Type S: 2840lbs, 210hp@7800, 143ft-lb@7000
2007 Camry I4 Auto SE: 3351lbs, 158hp@6000, 161ft-lb@4000
2007 Camry V6 Auto SE: 3483lbs, 268hp@6200, 248ft-lb@4700
Power to weight ratios:
RSX: 13.52lb/hp
I4 Camry: 21.21lb/hp
V6 Camry: 12.99lb/hp
Note, these are crank HP numbers. So theoretically, the V6 Camry would be slightly quicker.
Now, if we convert that to wheel HP (just using standard drivetrain losses of 15% for a manual and 20% for an automatic, which are typical for most cars)...
RSX (178.5whp) 15.91lb/whp
I4 Camry (126.4whp) 26.51lb/whp
V6 Camry (214.4whp) 16.24lb/whp
This means that, ultimately, the RSX would be quicker than the V6 camry, although very slightly. Less weight for each hp to move means it's quicker. In reality, I'd bet the V6 wouldn't even come close, because it's not geared for performance, it's geared for quiet operation, soft shifts, and good fuel economy. Put them both on a road course, and the RSX could lap the Camry without breaking a sweat.