I use SQL server Access and Oracle, but I have used SQLite and considering the size and function SQLite. It has it's place and again, the footprint is so small. It is great for embedding in smart phone apps, for retaining settings on webservers and client apps for quick prototypes as well. Another benefit is that it can be used on most platforms.
As suggested earlier I would also suggest doing more performance metrics but against SQL CE
Also the newer versions of SQLite (3.7) has Write ahead locking
And there's nothing like being able to drag and drop a few files and your
code runs without having to install SQL server on 150 users desktops
with different OS versions just to read a table.
We still lean heavily on MS Access but there is a lot of code maintenance with ever newer releases since we have different versions in use.
"There is nothing so useless as doing efficiently that which should not be done at all." - Peter Drucker