Using a VPS for mining would be best on Brand New Coin launches. Since the diff will be low and you can deploy the instance rather quickly you should be able to rack out some coins pretty fast.
Sustained mining on a VPS is not really a good idea, you will either break even or loose your shirt.