Sounds ideal. I really like the isolation of separate DB files per user.

In more complex systems though it feels like it's going to require quite a bit of orchestration.

The big option that SQLite opens up though is portability - I imagine one day just saying to customers that they can download their database and interface with it themselves or shift it to another provider.