I use a G1 (HTC Dream running Android). Everything syncs over 3G, as I have it set up with my Gmail account, and work email (exchange, using activesync with 3rd party app).
Unlike an iPhone, there's no need to ever connect your Android phone with your computer.
If you wish to transfer music or movies, simply connect it, it works as a USB mass storage device (just like a USB hard drive), and you can copy your files to the microSD card. Should work flawlessly with no software required.
Enjoy the many benefits of an Android phone