The problem is "remote" SQLite. Just run a "single" beefier box with in-process SQLite and Litestream backups to object storage and never have to think about RDBMS again. I'd wager there are 90%+ applications that would be better served, more performant, and cheaper with this design.
I'm able to handle around 200k/s on a sub $100 box. https://github.com/pairshaped/gleam_sqlite_benchmarks/blob/m...