Neon goes further than just "managed postgres". I would say one of their big features is just how fast and easy you can spin up new db/clusters. It's completely possible (encouraged) to spin up 1 DB per tennant and potentially spin u and tear down 1000's of databases.

It opens up some interesting ideas/concepts when creating an isolated DB is just as easy as creating a new db table.