I personally use FastCGI+SUExec to ensure that WordPress' PHP code executes under a specific user account other than Apache's. It does not address the possibility of WordPress code itself somehow being hacked, but it does provide some sort of sandbox protection to the site.
I'm not thrilled with WordPress' past security track record, but I think they have made it so easy to use that a lot of users simply throw the scripts up on a shared server without knowing exactly what they're doing so far as server configuration goes. I wonder how many WordPress blogs are exploited because of a stupid permission setup?
Here's where a lot of the security problems arise. As I mentioned, a lot of people are on a shared host and using mod_php. The only way they can make their files writable is to somehow give Apache write access to them. That opens up the possibility for other sites on the shared server to execute PHP that also writes to these files.
If you're stuck in this position, I'd recommend as a hack/workaround, to temporarily chown the files to www-data/apache. Perform the upgrade, then change ownership of the files back.
Ideally, if you're setting up your own server, I'd recommend FastCGI/SUExec:
http://www.howtoforge.com/how-to-set-up-apache2-with-mod_fcg...
You have much finer-grained control over how your PHP can execute. Alternatively, although I have no experience with it, you could try suphp to achieve a similar effect but by sticking with mod_php.
I host and keep 6 blogs up to date like this for friends and together with things like mod_security I've never had a problem with spam or being hacked.
I realise this is just anecdotal and isolated, but an upgrade doesn't get much simpler than "svn up".
And you can this to automatically install via SVN http://birdhouse.org/software/2008/04/wp-create/ (and there's a similar script for updating all the sites at once)