I've had my '07 V6 5-speed for 5 months and really haven't done anything except for the airbox mod and a K&N air filter. The K&N and airbox mod gave the car some extra pep. I'm very happy with it's performace from the factory. It is a quick car for a 4-door sedan. Btw...I live in Colorado at 6000ft, so it is definitly slower here than in Florida.
I've heard a set of headers and mid-pipe really opens up the exhaust (the cat-back flows well stock) and gets you a decent amount of hp. There is also the typical CAI and throttle-body mods. I've also heard about someone doing tuning on these cars, but I haven't researched it enough.
I love my V6 and would highly suggest it to anyone.