I run an architecture that's not terribly different from this. Unfortunately, the current hotness -- php-fpm -- doesn't work with suexec. The PHP pools are easily configured to run under nonprivileged user accounts but suexec provided a few other nice features that are no longer available.

Scalable no-downtime MySQL is still a total bitch though.