Dynamodb is great. A ton of services, including this site could literally be implemented with dynamodb alone.

As always, "it depends", but I'd argue DynamoDB has too many constraints and weird limitations: indexes, query language, item (row) sizes. Unless you really know what you're doing I would not suggest it. You'll likely paint yourself into a corner.