What great advances is this approach throwing out?
Most bloggers have a very simple use case: publish stuff that looks nice, generates an RSS feed, and maybe allows a comment thread. Most bloggers are not, and have no interest in becoming, sysadmins or DBAs.
My contention is that it is easy to set things up so you can blog with whatever app you want without leaving your data at the mercy of the next person to find an exploit.
Unless you check up on your blog several times a day --- and most people don't even check up on their blog several times a week --- it doesn't matter how streamlined WordPress has made its upgrade process.
My advice? If you host your own web apps at least take the responsibility to administer them. Wordpress has made huge improvements in their update process.
My upgrade process is this: * dump a copy of the database * disable plugins * copy the current public_html directory to a backup (just in case) * untar new release over the top of the old * run /wp-admin/upgrade.php * reenable plugins