Palm suffered from bad marketing and weak hardware. The OS on the other hand, WebOS, is the most fluid OS to date. It multitasks in a way that reminds you of a real OS. Developers have got many big name iPhone apps running on it with ease. You have to try a Pre for a week or two to understand the potential of the OS.
Gestures and Swipes to get out of programs (look ma!, no buttons). Notifications on this is a dream as well. They pop-up underneath your screen while you're doing whatever which helps not to distract you from a certain task, and you can swipe them off the screen to deal with later. Cards is another big feature of the OS. You swipe in between running programs and have live visual view of the apps that are running. That alone would make a tablet in a car a lot safer.
In regards to the cloud service, the only thing I sync are contacts off of my gmail account and other social networks over the internet. I really haven't had a need to sync with a desktop application yet. Maybe when more productivity apps get released I might want one but since Palm is with HP I'm sure they can afford to devout time into making one.
Oh did I mention the Touchstone...I charge my phone by placing it on a hockey puck. No more wire hassles at night.
I've been using a Pre since last September, my only gripes as of now is the need for better hardware. All the other software flaws have been fixed or can be with the large homebrew community that Palm welcomes with open arms unlike Apple.