I just upgraded to WordPress 3.0. No issues with the Automatic Upgrade (that I can see yet).

Seems pretty painless. In fact, I did it via my iPhone.

Next thing I should really do is upgrade/change my theme.