SimpleDB shifts the burden of database scaling and maintenance from the programmer. Being free from those worries is a hugely important consideration. Even if it means having to forgo the ability to do joins or order by.

And you can still use SQL (albeit restricted) on SimpleDB with some of the new wrapper libraries such as this one: http://code.google.com/p/simplejpa/