I had been worked on CommVault a while, and as a DBA, I think CommVault is working well for SQL 2005, but not for 2000, and no advantage for SQL 2008 since SQL 2008 can compress backup itself.

For the Dev refresh requirement, you may want to create CommVault script, and then create job on SQL, and then grant permission for developer to kick out job. This is complicate process, but can be done. CommVault "online help"(big red button on CommVault Concole) will be the only resource you can use, and their support team is useless on this issue.

Basically, you will have one command file and one input file on hand, which can be edited, and you can do point to time restore on different server.

The Cons are you have to have a CommVault user account to run this, and destination database name can't be changed.