I suspect you know the answer, though: people erroneously believe SQLite isn't up to the task—and then combine that with ego, my project needs a real database.
What do you mean by "odd man out"?
I see many projects that work with Postgres and MySql but not SQLite.