Can you specify the evironment for each poit?
I think:
connect to server -> ok
run command -> ok (you must have magerun installend on the server if you want to run this on server or you can add magerun in a folder of your project under SCM)
Download dump to local i think is not in the purpose of rocketeer (but i think you can find an alternative way to do this... i'm thinking about a script that send you the dump attached in an email
Run import command on production + extra hooks. yes you can do this
Is it possible to download some files after running a few commands?
Eg. I want to do something like this
Any ideas how to about something like this, or is that out of the scope for rocketeer?