Any good resources/advice on using Capistrano to deploy EE sites?
I've previously used Capistrano to deploy EE sites, though I've recently moved to using the web based DeployHQ as it doesn't require SSH access or for Git to be installed on the server, while still allowing rollbacks (based on SHAs/commits).
That said, here is a Gist of the last version of my cap recipe for deploying E via Git+SSH. This was based an amalgam the HiveLogic post linked in @Janvi's answer as well as This ShapeShed post and some bits from This GitHub repo too, all updated for EE2.
As such it also has a bunch of extra tasks for doing things like getting a SQL dump from the remote server, and importing it locally which you may or may not want. Feel free to make use of it if you can, but as I'm no longer using it I can't really help support it.
NB This recipe assumes that you are bootstrapping your config and making full use of config vars to move all paths (inc uploads) out of the DB. I have an extended version somewhere which runs the SQL dump through a migration script to fix any missed paths and empty tables that aren't needed across imports, such as
EDIT: There's also this article on deploying EE 2 with Capistrano
FWIW, I wrote a blog post (and made a video) on the topic relatively recently. The resources already mentioned are really great, but perhaps my write-up will help too.
A quick google search lead me to this:
DEPLOYING EXPRESSIONENGINE FROM GITHUB WITH CAPISTRANO http://hivelogic.com/articles/deploying-expressionengine-github-capistrano
Seems like this should cover most of it.