Check out Awesome Drop in the Android Market. It is a free app that allows you to drop a file onto your browser window (Awesome Drop from Dashwire Labs) and have it auto-magically download to your Android device. It works over 3G and Wifi.
You must use a HTML5 compatible browser. No account is needed.