How can I transfer video from my Sony AVCHD camcorder?
The new Final Cut Pro X natively supports AVCHD. The old Final Cut Pro Studio did not.

And the new Final Cut Pro X is much less expensive at only $300. 

You really should evaluate if it will meet your needs, and if your system has the specifications to run it.