I love SQLite, and I really want to run it in production, but my clients expect minimal data loss and downtime when one of my servers goes down.

The answer to that being running it on top of LiteFS or LiteStream seems like starts to make the setup a lot less simple and lot less battle tested, which kind of starts to negate the advantages over just running Postgres.