The Address Book application in OS X Lion is sorely lacking in its ability to sync & combine contacts from different sources. Does anyone know of a good replacement?

Update - My Holy Grail:

• I use a personal Gmail account and a work Google Apps account.
• I'd like to have the same info available on my iPhone, iPad, work Mac, home Mac, and Google via a browser.
• While I'm at it, let's throw in Twitter and Facebook, though those are much lower priority.
• I'd like a local copy of all the info in case the cloud isn't available.
• iCloud syncing isn't really a priority, since I use Google for that, but I could see switching what I can if things would work better.

Currently, I'm seeing a lot of duplicates, or near duplicates in both iCal & AddressBook, and it's very difficult (impossible?) to see where a given contact or appointment is coming from. In the past I used Spanning Sync to keep google and the local in sync. Perhaps that + iCloud is where the dupes are coming from.