Indeed. Everyone who uses sqlite will get burnt by this one day and spend a lot of time chasing down errant write-upgraded transactions that cling on for a little bit longer than intended.
It's just weird that it's set to 0 by default rather than something resonable like 3000 or 5000 ms.