How does that compare to Aurora Postgres, which can do the same thing? (If it's just "Aurora Postgres, but you can run it on not-AWS", that's still a useful product. But do they have advantages other than that?)
Aurora Postgres does not have a free tier, unlike Neon. AWS has a $100 free tier across all services for 12 months, but Neon is free forever as long as your usage is low.
Biggest differences are that Neon can scale to zero (and not charge you) and it has branching as a native concept. This means that it can provision a new DB nearly instantly (as opposed to waiting a few minutes for Aurora) and it can do instant copy on write branching.
So Neon is a lot better for AI agents that are running experiments.