OK, for those of us without Outlook/Microsoft Exchange, there's a sync program called CompanionLink for Google that seems to solve most of the sync problems. I'm using the 15-day demo and so far it is working very well. There are a few quirks due to the inadequacies of the Google cloud apps, but the CompanionLink does maintain category listings. It handles the notes by converting them into contacts with |M| spacers on each side to denote them as notes or memos. Not the best but at least I can search for my notes easily.
Companion link also brings all info from Outlook and installs it in the Contact list of Google and into Google Calendar, which is then downloaded to your DROID real time. You can start the sync and within minutes the Google Contacts on the Web and your phone are already showing updated and added contacts, for instance.
This has solved many of the problems I had when I did the first transfer of my contacts from my Treo/OUtlook into Google Contacts -- which didn't put the fields in the proper position and didn't even include addresses. I recommend that if you have done a bulk transfer to Google using .csv files that you erase all your Contacts in Google (unless for some reason you've added a bunch that you don't have in OUtlook) and then run CompanionLink the first time so that Outlook updates Contacts properly. That way you won't have to go into Google and delete the screwed up duplicates.
The only major problem I've seen so far is that I'm not sure the Tasks are getting updated properly. CompanionLink does have a rich set of options so it's possible that it can do more than I've gotten from it so far. I know it will do scheduled updates for you, although I prefer to do them manually. More research will be required, but I'm much happier now. CompanionLink is $40 and while I resent having to pay extra for Outlook Sync, which is free on Palms, I like the DROID's other features enough to shell out the extra cash.
