AWS is more expensive for long running instances (Although not so much if you reserve them).

However where it (and Rackspace + others) shine is using the API to spin up instances for jobs in scripts, or have your monitoring automatically spin up additional instances to scale up when load increases.