Don't take this the wrong way, because I think serverless postgres is a major achievement. But would you say multitenant means use Nile, and for everything else, use neon?
If you are building a static website (usually your website) or building a social networking product like Facebook, I would not recommend Nile. We recommend Nile for any usecase where you are serving multiple groups of users. In our experience, 95% of applications in the market today seem to fall into this category.