This is a favorite subject of mine!
I got my Droid over a week ago, and getting a password safe was my #1 priority. I did some digging and SplashID rose to the top of the list, so I tried it with it's trial version and then bought it.
First off, my previous password safe was eWallet, and I had a rude awakening that eWallet DOES NOT have any useful export functionality. It exports a non-delimited txt file which is almost useless. But that's not Splash Data's fault.
Next, on to Splash Data's product. While I am OK paying for this software, and it appears to be at/near the top of the heap for this type of product, it's really not ready for prime-time. The PC software is unstable, simple functions such as "Delete" don't work reliably, and customizing fields for each type of "card" is half-baked - doesn't really work. I am in the software business and can say that I don't recall such a poorly developed piece of commercial software being released on the market.
Why am I OK with letting them keep my money? The primary functions, such as creating a record, displaying info, and sync'ing work. I trust that they will fix the very obvious bugs (I gave them a list!) and then I think they will have a commercially-viable, stable product.
Regarding sync'ing, I just followed their instructions and it works. I only works as of now via wifi, so you have to make sure your wifi is set to "On" on the Droid, that the app is running on your PC, and that your PC is currently connected to your wifi net. Be sure to get the right IP info identifying your PC. I find the sync to be reliable and extremely fast.
Hope this helps!