We are working on https://github.com/antistatique/capdrupal for some months now. This is a capistrano recipe to deploy drupal website. It works with multistage...
It's far from perfect but feedback more than welcome, please use the issue at github.
I believe the project is still quite relevent and I do not think I am the only one that stumbles here. Page-owner give this page a link to the project? I hint of love is what this page needs!
I move the project to a capistrano 3 plugin: https://github.com/capistrano/drupal-deploy that is in the official Capistrano organization. If you have any support request/bugs, please open an issue on github.
Drupal is a registered trademark of Dries Buytaert.