We host our marketing website on it, a static Astro build sitting in S3 with CloudFront in front. Pages load fast for visitors in every region we checked, and we barely pay anything for it at our traffic level. What I like most is CloudFront Functions. We use them for URL routing and to 301 our old blog subdomain to the new paths, so there is no server to run just for redirects. Having a separate distribution for stage and prod is easy too, we test the exact same setup on stage before pushing to prod. HTTPS with ACM certificates was basically set and forget. Review collected by and hosted on G2.com.
Changes are slow to roll out. Any time we edit a distribution setting or publish a new version of a function it sits in "Deploying" for several minutes before it's live everywhere, so a one line redirect fix turns into a wait and refresh loop. When something looks wrong right after a deploy it's hard to tell if it's actually broken or just hasn't propagated yet. On top of that you have to remember to invalidate paths or people keep seeing the old page for a while. Review collected by and hosted on G2.com.