From my personal experience, AWS is extremely powerful (especially on security and networking). If you cross the learning curve, and know automation or Infrastructure as Code (e.g. Terraform) then it's fast and easy to build almost any architecture.

But yes, it's overkill for a simple website or a simple setup (if one is not familiar with AWS).