Isn't the opposite true? It's fine for under 10 instances when you're first starting up and still flexible, but over that you're better off going colo?
I've described AWS as a great "deal" for very small and for very large customers. For people in the middle, not so much.
Also depends on what you consider a deal -- the lower tier hardware works for a Wordpress blog, but not necessarily for much more. For the price, a good Linode or even a dedicated server will get you more bang for the buck.