If your access patterns are fixed and not going to change, if your schema is pretty much solidified, then yes, I don't doubt that at all. But few things I've worked on have had such stable access patterns or schemas that they would benefit.

I enjoyed solving the challenges around using DynamoDB way more than I enjoyed using it on an ongoing basis.