Personally, I find AWS's pricing complicated, and there are so many different services that it's confusing. I think it's mostly a UX issue, but it's really overwhelming.
DO, Lonnie Linode, and Vultr are very simple, so that's what I use. Perhaps if I start needing more from my hosting I'll look at AWS, but it's just not worth my time to figure it out for the scale of projects I'm doing.
I have used it both for work and in personal projects and haven't ran into any issues/headaches.